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.
I have following data set:
Date | Value |
1.2.2019 | 400 |
15.2.2019 | 50 |
23.2.2019 | 100 |
24.2.2019 | 150 |
5.3.2019 | 80 |
19.3.2019 | 20 |
23.3.2019 | 35 |
25.3.2019 | 70 |
1.4.2019 | 15 |
I like to give end user a change to filter dates and after that calculate value for the last month... based on selected values:
Value | PrevMonth | |
23.2.2019 | 100 | |
24.2.2019 | 150 | |
5.3.2019 | 80 | 250 |
19.3.2019 | 20 | 250 |
1.4.2019 | 15 | 100 |
I have been trying to do this many ways already and don't seem to get it to work. Can anyone help me with this?
Solved! Go to Solution.
Hi @Anonymous
You may try below measure:
Measure = CALCULATE ( SUM ( Table1[Value] ), FILTER ( ALLSELECTED ( Table1 ), MONTH ( Table1[Date] ) = MONTH ( MAX ( Table1[Date] ) ) - 1 ) )
Regards,
Cherie
Hi @Anonymous
You may try below measure:
Measure = CALCULATE ( SUM ( Table1[Value] ), FILTER ( ALLSELECTED ( Table1 ), MONTH ( Table1[Date] ) = MONTH ( MAX ( Table1[Date] ) ) - 1 ) )
Regards,
Cherie
Hi @v-cherch-msft ,
It is not work when we have 2 years of data i.e., 2018 and 2019. Is is working when we have 1 year data alone. It is getting summed up for nov month 2019 as well as 2018 whenever the month value is returning as 11.
Thanks
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |