Forum Discussion

daxbeginner's avatar
daxbeginner
Frequent Visitor
6 years ago
Solved

MDX to Dax Code Migration

Hi,   I am struggling a bit to rewrite the below MDX code to DAX equivalent:   M1: Iif(Isleaf([Invoice].[Invoice ID]),[Measures].[Product Invoice Amount EUR Days Due Date To Payment Date], SUM(D...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi daxbeginner ,

    Maybe you can try this:

    M1:

    =
IF (
    ISFILTERED ( 'Invoice'[Invoice ID] ),
    [Product Invoice Amount EUR Days Due Date To Payment Date],
    SUMX (
        ALLEXCEPT ( 'Invoice', 'Invoice'[Your Level Column] ),
        [Product Invoice Amount EUR Days Due Date To Payment Date]
    )
)

    M2:

    =
IF (
    ISFILTERED ( 'Invoice'[Invoice ID] ),
    INT ( [Invoiced Amount EUR] ),
    INT (
        SUMX (
            ALLEXCEPT ( 'Invoice', 'Invoice'[Your Level Column] ),
            [Invoiced Amount EUR]
        )
    )
)

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
6 years ago

Hi daxbeginner ,

Maybe you can try this:

M1:

=
IF (
    ISFILTERED ( 'Invoice'[Invoice ID] ),
    [Product Invoice Amount EUR Days Due Date To Payment Date],
    SUMX (
        ALLEXCEPT ( 'Invoice', 'Invoice'[Your Level Column] ),
        [Product Invoice Amount EUR Days Due Date To Payment Date]
    )
)

M2:

=
IF (
    ISFILTERED ( 'Invoice'[Invoice ID] ),
    INT ( [Invoiced Amount EUR] ),
    INT (
        SUMX (
            ALLEXCEPT ( 'Invoice', 'Invoice'[Your Level Column] ),
            [Invoiced Amount EUR]
        )
    )
)

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.