Forum Discussion
DAX IDEAS PLEASE
Hi ChrisMendoza, I didnt realize that one... eventhough I was playing with "relative date filtering" in the visual and it work for months no for weeks... and to make it work correctly for months I made a DAX... any native power BI feature for what I was looking for worked properly without getting smart and add a DAX to make it work... the native solution you share doesnt work 100%... I chose the last 4 weeks and it shows 2... take a look at my pbix. and play... my DAX for month could be usefull for you (keep it) and tell me what you think :)
I agree, the pre-built Relative Slicer is not 100% because your fact table has not been updated since March 1, 2018. Last 4 weeks (calendar) from today is March 3, 2018; therefore 'no data' is displayed. The same is said for Last 4 Weeks from today is March 6, 2018.
Seems your solution is something along the lines of Find the last date in the fact table, do some math to find the last x weeks, then do some more math (e.g. sum) based off the x results.
I think Ashish_Mathur's comment is probably the direction you need to head.
Still work it on it with no results...If I figure something out Ill let you guys know , ChrisMendoza, Ashish_Mathur