Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |