Hi,
using the formula to create the date quarter of the year
, which I then round up.
Please Login or Register to view this content.
works fine in power pivot data model but when I've tried to use the same in power bi I get a zero? ,
The
So, Month 1 = 0 ; 2,3,4 = 1 ; 5,6,7 = 2 ; 8,9 , 10 = 3 ; 11 , 12 = 4 ?Please Login or Register to view this content.
Can someone explain what is happening ?
Richard.
Last edited by Dicken; 08-17-2022 at 09:05 AM. Reason: need to add something.
seems you are using integer numbers, not floating point. so the result of dividing by 3 is already rounded down.
If you don't know how to force using flaoting point, not integer mathematics a simple workaround shall be something like
Please Login or Register to view this content.
Best Regards,
Kaper
Thanks, Kaper,
Good guess I do not know how " force using floating point" , I shall have to look into this, if you have any reading recomendatdions, apart from MS Docs ( not my favorite reference point) please let me know.
Thank you,
Richard.
Hi Kaper,
Just to add I have found that if I dont' use the Month Function,
just,Please Login or Register to view this content.
It behaves exactly as I would expect, ( as in excel) , your fix certainly works, but not sure why.
"Please Login or Register to view this content.
Richard.
My workaround is based on observation that every first month of the quarter returns previous quarter (in case of Jan it's 0, because there is no quarter before Q1) so just by adding 1 to month we are there.
as for "forcing floating point) - may be
would doPlease Login or Register to view this content.
This is just a side comment as the thread is already marked SOLVED - Thanks for that, and for reputation point
Thanks for the help, and you're welcome to the mark up.
RD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks