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.
Hey Everyone, i need help with below question
I have two tables
i want to calculate difference of count(AllIncidents) - count(ActionableTickets) per month basis. (for all months)
e.g
Desired Outcome: another table
Year Month Difference
2021 Jan 2003
2021 Feb 3615
2021 Mar 7369
2021 Apr 1628
2021 May 1947
..... ...... ......
Can some one please help me on this ?
I would appreciate any input on this. Thanks
Solved! Go to Solution.
Thanks for the reply, but how would it calculate the difference between count(AllIncidents) - count(ActionableTickets) for each month
A most straightforward solution is to simply merge these 2 table by columns Year&Month in Power Query, it's done.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks for the reply, but how would it calculate the difference between count(AllIncidents) - count(ActionableTickets) for each month
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |