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 Team,
I need to show the data greater then current month and less then - 12 month.
Month | data |
2019-03 | 15 |
2019-04 | 10 |
2019-05 | 12 |
2019-06 | 23 |
2019-07 | 12 |
2019-08 | 21 |
2019-09 | 54 |
2019-10 | 62 |
2019-11 | 26 |
2019-12 | 54 |
2020-01 | 4 |
2020-02 | 54 |
2020-03 | 53 |
output | |
2019-04 | 10 |
2019-05 | 12 |
2019-06 | 23 |
2019-07 | 12 |
2019-08 | 21 |
2019-09 | 54 |
2019-10 | 62 |
2019-11 | 26 |
2019-12 | 54 |
2020-01 | 4 |
2020-02 | 54 |
Solved! Go to Solution.
Thanks ashish for your input. i got the solution by the below DAx code.
work = var y=CALCULATE(SUM(Append1[data]),FILTER(Append1,Append1[Month]<Value(max(Append1[Month]))&& Append1[Month]>TODAY()))
Return y
Thanks,
Rajveer.
Hi,
I have solved a similar question here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hope this helps.
Hi Ashish,
I am not able to open the excel which you have provided. Can you please let me know how we can implement ths using DAX expression.
Thank,
Rajveer
Hi,
What problem are you facing in opening the file?
Thanks ashish for your input. i got the solution by the below DAx code.
work = var y=CALCULATE(SUM(Append1[data]),FILTER(Append1,Append1[Month]<Value(max(Append1[Month]))&& Append1[Month]>TODAY()))
Return y
Thanks,
Rajveer.
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 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |