Hi,
To start I do know there is the quarter function.
I have tried dividing a month number in power bi ;
Quarter = DIVIDE( dDate[Month Number] , 3 )
as I was then going to make the quarter and from that fiscal quarter, so in excel ;
but I don't get 0.33333 for 1/3, I get 0 ? why?
Richard.
To start I do know there is the quarter function.
I have tried dividing a month number in power bi ;
Quarter = DIVIDE( dDate[Month Number] , 3 )
as I was then going to make the quarter and from that fiscal quarter, so in excel ;
Excel Formula:
IF(ROUNDUP((MID(TEXT(E4, "dd/mm/yy"),4,2)/3),0)-1= 0,4, ROUNDUP((MID(TEXT(E4, "dd/mm/yy"),4,2)/3),0)-1)
but I don't get 0.33333 for 1/3, I get 0 ? why?
Richard.