Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Am new to power bi dax, i am trying to display last 4 weeks data with below dax formula.I have Date table and estalished connection with main table.
Last4Weeks = IF(DATEDIFF(ClosedTickets[PResolveDate],TODAY(),WEEK)<5 && WEEKNUM(ClosedTickets[PResolveDate]) <> WEEKNUM(today()),"YES" ,"NO")
I got below result with above DAX
Getting Extra week with above DAX, please correct me
Hi @Narasimha
Have you tried
Last4Weeks = IF(DATEDIFF(ClosedTickets[PResolveDate],TODAY(),WEEK)<4 && WEEKNUM(ClosedTickets[PResolveDate]) <> WEEKNUM(today()),"YES" ,"NO")
If this works it's probably because the current week is week 0 for the DATEDIFF calc.
Hi @Narasimha
I think there is a mis-match on the weekstarting date, so you may want to use the optional argument on the WEEKNUM function based on your week preference
WEEKNUM([date] , 1) = week begins on a Sunday through Saturday (US style)
WEEKNUM([date] , 2) = week begins on a Monday through Sunday (Rest of the universe style).
So perhaps try variations on
Last4Weeks = IF(IFERROR(DATEDIFF(ClosedTickets[PResolveDate],TODAY(),WEEK),-1)<5 && WEEKNUM(ClosedTickets[PResolveDate],1) <> WEEKNUM(today(),1),"YES" ,"NO")
Hi there,
I am new to PBI and am using your solution for the same problem, to say wether "yes" or "no" Calendar_Date from my Dates table belong to the last four weeks from today. I get an error that says "The end of the input was reached.