cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allpat64 Frequent Visitor
Frequent Visitor

dax expressions

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ChrisHaas Established Member
Established Member

Re: dax expressions

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.

2 REPLIES 2
Highlighted
ChrisHaas Established Member
Established Member

Re: dax expressions

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.

Allpat64 Frequent Visitor
Frequent Visitor

Re: dax expressions

Thank You CHris