Forum Discussion

misunika95's avatar
misunika95
Frequent Visitor
7 years ago
Solved

Dax to M language

Hi everyone!

 

I wanted help transforming the following DAX code to M language: 

 

Classification = 
var __currentAccountNumber = 'Accounts Receivable'[Account Number]
var __currentDebt = 'Accounts Receivable'[Debt USD]
var __currentInvoiceType = 'Accounts Receivable'[Invoice Type]
var __currentTimeInterval = 'Accounts Receivable'[Time Interval]
var __sumOfDebtForCurrentClient = 
    SUMX(
        FILTER(
            'Accounts Receivable',
            'Accounts Receivable'[Account Number] = __currentAccountNumber
        ),
        'Accounts Receivable'[Debt USD]
    )
var __classification =
    SWITCH( TRUE(),

        __sumOfDebtForCurrentClient < 0, 
            "Credit Balance",
            
        __currentDebt < 0 && __currentInvoiceType in {"AA", "BB", "CC", "DD"},
            "Unapplied Payment",

      
        __currentTimeInterval
    )
return
    __classification

I initially tried to add this column but turns out I need it to be added as steps in the Query Editor so I can use the result to merge another table.

 

Thanks!

 

1 Reply