Forum Discussion
Problem with Variation measure
Hello everyone. I have a Date table called Dim_Date2 and it doesn't connected to my Fact table Sales for others reasons. So, I have to filter date in each measure. I have the next measure to calcul...
Hi
You can try: dateadd(LASTDATE(Dim_Date2[Date]),-1,day)
Previous Sales = calculate([Sales],dateadd(LASTDATE(Dim_Date2[Date]),-1,day))
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com