Forum Discussion
RenanPNog
Helper I
Helper IDax Week Calculation - Power BI
Hey folks! I'm having some trouble trying to calculate weeknumbers.... That's because, i have a sells time period, and i want to check how many weeks are left of that period. I've tried DATEDIFF f...
Payeras_BI
Solution Sage
Solution SageHi RenanPNog ,
And why not using DATEDIFF with WEEK as interval?
I hardcoded the dates for demonstration purposes.
RenanPNogHelper I
Helper IHello, J.Payeras.
The reason is because if i bring week as argument, it won't return me the expected result, check it out:
Also, please, check my top comment, where i show expected weeknum result for each day.
Thanks in advance.