Forum Discussion

OPS-MLTSD's avatar
OPS-MLTSD
Post Patron
2 years ago
Solved

Translate DAX formula to Power Query

Hello, I was wondeirng if someone could please help me translate this DAX formula to power bi power query formula:   New_Column = if(isblank(table[PAYMENT_DATE]),BLANK(),if(month(table[PAYMENT_DAT...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    OPS-MLTSD try this in Power Query:

     

    if [Payment_Date] = null then null else if Date.Month([Payment_Date]) < 4 then Number.ToText(Date.Year([Payment_Date])-1)&"-"&Number.ToText(Date.Year([Payment_Date])) else Number.ToText(Date.Year([Payment_Date]))&"-"&Number.ToText(Date.Year([Payment_Date])+1)

     

parry2k's avatar
parry2k
Super User
2 years ago

OPS-MLTSD try this in Power Query:

 

if [Payment_Date] = null then null else if Date.Month([Payment_Date]) < 4 then Number.ToText(Date.Year([Payment_Date])-1)&"-"&Number.ToText(Date.Year([Payment_Date])) else Number.ToText(Date.Year([Payment_Date]))&"-"&Number.ToText(Date.Year([Payment_Date])+1)

 

OPS-MLTSD's avatar
OPS-MLTSD
Post Patron
2 years ago

parry2k 

do I write this above formula in advanced editor in power query?