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.
Hello!
I'm scratching my brain out of this calculation.. Can anyone maybe help me on the way if it's even possible? 🙂
I'm trying to calculate difference between multiple columns in a Matrix.
I just want to see the different between each "Date" column of my choice, for example to see how many calls where made in "2018-03" vs "2019-03".
So the "Total Difference" is the correct value but since i want to select more than just the two dates then i can't use the "Total" value anymore because i just want to see the difference to the "Count of Call ID" value of the right column.
The "Difference" measure is:
Difference = CALCULATE ( COUNT('Table1'[Call ID]), FILTER ('Table1', 'Table1'[Date] = MAX ('Table1'[Date])) ) - CALCULATE ( COUNT('Table1'[Call ID]), FILTER ('Table1', 'Table1'[Date] = MIN ('Table1'[Date])) )
Example data:
Solved! Go to Solution.
@Christian_Power ,
Create the following column in your table.
NEWDATE = DATE(LEFT(Table1[Date],4),RIGHT(Table1[Date],2),1)
Then create a new table using DAX below.
Table = SUMMARIZE(Table1,Table1[Cities],Table1[Date],Table1[NEWDATE],"countvalue",COUNT(Table1[Call ID]))
Create the diff column in the new table as below.
diff = var pre= CALCULATE(FIRSTNONBLANK('Table'[countvalue],1),FILTER('Table','Table'[NEWDATE]>EARLIER('Table'[NEWDATE])&&'Table'[Cities]=EARLIER('Table'[Cities]))) return IF(ISBLANK(pre),BLANK(),pre-'Table'[countvalue])
Regards,
Lydia
@Christian_Power ,
Create the following column in your table.
NEWDATE = DATE(LEFT(Table1[Date],4),RIGHT(Table1[Date],2),1)
Then create a new table using DAX below.
Table = SUMMARIZE(Table1,Table1[Cities],Table1[Date],Table1[NEWDATE],"countvalue",COUNT(Table1[Call ID]))
Create the diff column in the new table as below.
diff = var pre= CALCULATE(FIRSTNONBLANK('Table'[countvalue],1),FILTER('Table','Table'[NEWDATE]>EARLIER('Table'[NEWDATE])&&'Table'[Cities]=EARLIER('Table'[Cities]))) return IF(ISBLANK(pre),BLANK(),pre-'Table'[countvalue])
Regards,
Lydia
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |