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
I have a table of forecast with 2 columns for months, DemandMonth and SnapMonth (see below, all in date format), and the DemandMonth is linked to MonthDate in the time master (see below). The objective is to sum Value in forecast based on the selected Monthdate plus the related SnapMonth.
The 1st phase is simple, just sum the value of the month selected. I did a measure below which works.
Time Table
Solved! Go to Solution.
@Anonymous , if they connected the sleected value is no a good idea , If the time table is disconnected
Try like
Measure1 = CALCULATE(SUM('Forecast'[Value]),FILTER('Forecast',[DemandMonth] in values('Time'[MonthDate])&&'Forecast'[SnapMonth]=SELECTEDVALUE('Time'[SnapMonth])))
Measure2 = CALCULATE(SUM('Forecast'[Value]),FILTER('Forecast',[DemandMonth] In values('Time'[-1MonthDate]) && 'Forecast'[SnapMonth] in values('Time'[-1SnapMonth])))
Also explore userelationship, if you want to need one table at a time
https://www.youtube.com/watch?v=e6Y-l_JtCq4
@Anonymous , if they connected the sleected value is no a good idea , If the time table is disconnected
Try like
Measure1 = CALCULATE(SUM('Forecast'[Value]),FILTER('Forecast',[DemandMonth] in values('Time'[MonthDate])&&'Forecast'[SnapMonth]=SELECTEDVALUE('Time'[SnapMonth])))
Measure2 = CALCULATE(SUM('Forecast'[Value]),FILTER('Forecast',[DemandMonth] In values('Time'[-1MonthDate]) && 'Forecast'[SnapMonth] in values('Time'[-1SnapMonth])))
Also explore userelationship, if you want to need one table at a time
https://www.youtube.com/watch?v=e6Y-l_JtCq4
Thanks@amitchandak, I tried to disconnect the time table with the forecast, and found it works!!!!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |