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 am trying to do a simple calculation that is not being very easy to do. I am trying to find the difference in quantity for each month in 2019 and 2020. I split out the creation date into Month and Year so I can total them and then find the difference. My visualization has three columns and I am trying to calculate the forth (see below). ALL the data is in one Table. My row is Month, column is Year and value I am summing is Drop Quantity. I tried different commands but I guess I just don't know DAX good enough yet.
Month | 2019 | 2020 | Diff |
1 | 555 | 444 | |
2 | 666 | 222 | |
3 | 777 | 555 | |
4 | 888 | 444 | |
5 | 999 | 333 | |
6 | 111 | 50 | |
7 | 222 | ||
8 | 333 | ||
9 | 444 | ||
10 | 555 | ||
11 | 666 | ||
12 | 777 |
Solved! Go to Solution.
Not proud of this one but here goes:
Create two measures
Thank you, that worked! I read so many different ways of doing it I confused myself. I think your solution was the easiest way to go. Thanks again.
Not proud of this one but here goes:
Create two measures
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |