Forum Discussion
DAX IDEAS PLEASE
Dear Colleagues Im not getting so smart today and I need your help: Im trying the following: I need to create a chart out of my data always getting the last 5 or 4 weeks (Axis Y quantities, axis ...
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