Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 calculate Sales and Previous Sales:
Sales:=CALCULATE(SUM(Fact_Sales[SalesAmount]), FILTER(Fact_Sales,Fact_Sales[SalesDate]>=[MinimumDate]&&Fact_Sales[SalesDate]<=[MaximumDate]))
Previous Sales:=CALCULATE(Fact_Sales[Sales],DATEADD(Dim_Date2[Date],-[SelectedDays],DAY))
MaximumDate:MAX(Dim_Date2[Date])
MinimumDate:MIN(Dim_Date2[Date])
SelectedDays:CALCULATE(DISTINCTCOUNT(Fact_Sales[KeySalesDate]),FILTER(Fact_Sales,Fact_Sales[SalesDate]>=[MinimumDate]&&Fact_Sales[SalesDate]<=[MaximumDate]))
And the variation is the subtraction of both.
Previous Sales measure works if I select an specific date, but if I select the same date with a Year, month and day... it doesn't work .
I hope you can help me.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |