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 Everyone,
I need help in getting the difference between two columns. I want to get the difference of those number in 2017 and in 2018. The 2017 and 2018 is inside the same column.
Thanks!
Solved! Go to Solution.
This is unfortunately the problem with Using Columm Field.
You will get a MEASURE for each distinct value of the Column
There are 2 ways to deal with it
1) you can hide the extra MEASURE Column...hide the totals.....But you will have to adjust the Word wrap properties
I do not recommend this.
2) Another approach is to Remove the YEAR from columns and instead use 3 MEASURES as follows.
Put these MEASURES in the VALUES section
2018=CALCULATE ( Expression, Table1[Year] = 2018 ) 2017=CALCULATE ( Expression, Table1[Year] = 2017) Difference = [2018] - [2017]
Try this pattern
Measure = CALCULATE ( Expression, Table1[Year] = 2018 ) - CALCULATE ( Expression, Table1[Year] = 2017 )
What do I put for the Expression? COUNT(...)?
I have obtained the difference. However, it is showing at every part of the column as shown in the image below. Is it possible to make something like:
Year 2017 2018 Difference
With Mobile 7 5 -2
This is unfortunately the problem with Using Columm Field.
You will get a MEASURE for each distinct value of the Column
There are 2 ways to deal with it
1) you can hide the extra MEASURE Column...hide the totals.....But you will have to adjust the Word wrap properties
I do not recommend this.
2) Another approach is to Remove the YEAR from columns and instead use 3 MEASURES as follows.
Put these MEASURES in the VALUES section
2018=CALCULATE ( Expression, Table1[Year] = 2018 ) 2017=CALCULATE ( Expression, Table1[Year] = 2017) Difference = [2018] - [2017]
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |