Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
It's me again, just need some help in getting the difference between 2 month columns in my report using Matrix visualization
The months are automatically filtered using Last 2 Calendar Months
Thanks as always!
Solved! Go to Solution.
In this case, you would need a minimum of three measures. I'm assuming you already have two measures created. I am hoping my assumption is correct. If not you'll need to create those measures.
1 for the sum of the last 2 months
1 for the sum of the last 1 month
You would then take the sum of both and subtract the other. In your case the formula would be..
Delta := [Last1Month] - [Last2Month]
Hi @mangchaaBI ,
I think you'd better use a table visual.
This is my test table:
Please try following DAX to create three new columns:
Last 2 month_August = CALCULATE(SUM('Table'[Value]),FILTER('Table',MONTH('Table'[Date])=8 && 'Table'[ItemName]=EARLIER('Table'[ItemName])))
Last 1 month_September = CALCULATE(SUM('Table'[Value]),FILTER('Table',MONTH('Table'[Date])=9 && 'Table'[ItemName]=EARLIER('Table'[ItemName])))
Difference = [Last 1 month_September] - [Last 2 month_August]
Create a table visual:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In this case, you would need a minimum of three measures. I'm assuming you already have two measures created. I am hoping my assumption is correct. If not you'll need to create those measures.
1 for the sum of the last 2 months
1 for the sum of the last 1 month
You would then take the sum of both and subtract the other. In your case the formula would be..
Delta := [Last1Month] - [Last2Month]
Hi @hnguy71 I don't have the measures created yet, but I think I'm getting your instructions, can take it from here, thanks!
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |