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.
Is there a cleaner way to write this expressions?
YTD_Variance_Matrix = Calculate(TOTALYTD([MTD_Actuals_Matrix],V_FS_DIM_DATE[act_date])-TOTALYTD([MTD_Budget_Matrix],V_FS_DIM_DATE[act_date]),KPI_Finance_Matrix[Group]="Revenue")&
(Calculate(TOTALYTD([MTD_Budget_Matrix],V_FS_DIM_DATE[act_date])-TOTALYTD([MTD_Actuals_Matrix],V_FS_DIM_DATE[act_date]),KPI_Finance_Matrix[Group]="Operating Expenses"))
THe output is coming out as a text value, need to convert to a numeric, for formatting purposes
Solved! Go to Solution.
First of all, I put your code in www.daxformatter.com to come up with the following:
YTD_Variance_Matrix = CALCULATE ( TOTALYTD ( [MTD_Actuals_Matrix], V_FS_DIM_DATE[act_date] ) - TOTALYTD ( [MTD_Budget_Matrix], V_FS_DIM_DATE[act_date] ), KPI_Finance_Matrix[Group] = "Revenue" ) & ( CALCULATE ( TOTALYTD ( [MTD_Budget_Matrix], V_FS_DIM_DATE[act_date] ) - TOTALYTD ( [MTD_Actuals_Matrix], V_FS_DIM_DATE[act_date] ), KPI_Finance_Matrix[Group] = "Operating Expenses" ) )
You can see about halfway down you use the character "&".
This will concatenate the 2 otherwise numeric values into a single text string, probably not what you want.
Consider replacing that & with a + or a - depending on the arithmetic you need to perform.
First of all, I put your code in www.daxformatter.com to come up with the following:
YTD_Variance_Matrix = CALCULATE ( TOTALYTD ( [MTD_Actuals_Matrix], V_FS_DIM_DATE[act_date] ) - TOTALYTD ( [MTD_Budget_Matrix], V_FS_DIM_DATE[act_date] ), KPI_Finance_Matrix[Group] = "Revenue" ) & ( CALCULATE ( TOTALYTD ( [MTD_Budget_Matrix], V_FS_DIM_DATE[act_date] ) - TOTALYTD ( [MTD_Actuals_Matrix], V_FS_DIM_DATE[act_date] ), KPI_Finance_Matrix[Group] = "Operating Expenses" ) )
You can see about halfway down you use the character "&".
This will concatenate the 2 otherwise numeric values into a single text string, probably not what you want.
Consider replacing that & with a + or a - depending on the arithmetic you need to perform.
Thank You CHris
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |