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,
I am trying to count how many names have positive changes from last year.
I can manage to:
1) create a measure for the Revenue from the previous year (called Revenue Last Year)
2) create a measure for the difference between 2 years (called changes)
3) identify at row-level which name has positive changes (called positive count) - but pretty sure it is not correct!
The problem is the Total supposed to 2, not 5....
Note:
- I have read through the posts regarding Measure Totals but none of them is involved time intelligence measure like my case. (The only similar case I found, there is no solution!! )
- Hoping to see DAX solution for a calculated measure, not calculated column, please.
I guess it is something to do with time intelligence and blank (because some years there is no data).
Here is the pbix file - https://drive.google.com/open?id=1psK-p7VV1-5YDP7NW-BJMVLYeB262djw
Thanks
Solved! Go to Solution.
Hi @Mariusz,
Thank you!!! I can't believe I didn't try that... I guess I still don't truely understand DAX..
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 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |