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.
Hi Experts
Kindly ref to measure ACT 1 tables Fact Sales.
I am trying to do a 1 to 1 comparison between current v prior forecast. The current forecast filters correct for all slicers on page.
The prior forecast messure does not work correct for slicers Month, MTD YTD and FY and the Quarters.
Help been stuck on this for 2 days.
https://www.dropbox.com/s/0cjsoldsrlxuj6u/sampleData_.pbix?dl=0
Solved! Go to Solution.
@Anonymous , I looked at the file, Not able to get your prior year cal With use Act1. Why all and calendar 2
ACT1 = CALCULATE(Sum(FACT_SALES[Sales]),
ALL('Calendar'),
USERELATIONSHIP('Calendar'[Date],Calender_2[Date]))
Why not prior like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
@Anonymous , I looked at the file, Not able to get your prior year cal With use Act1. Why all and calendar 2
ACT1 = CALCULATE(Sum(FACT_SALES[Sales]),
ALL('Calendar'),
USERELATIONSHIP('Calendar'[Date],Calender_2[Date]))
Why not prior like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Hi Amit, kindly ignore the YTD and Quarter slicers
Can you get the Prior Forecast to filter data based on the month selection...please this is causing me nightmares...stuck for 2 days..
I understand you are a clever super users.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |