Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Assistance Convert Dax into Power Query

Hi,

 

Can someone help me change this DAX into a Power Query so I can merged the values with another table?

 

Regards,

tksnota

 

Classification =
IF('Cost Classification'[GLAccount] >= 0 && 'Cost Classification'[GLAccount] <= 49415, "BLANK",
IF('Cost Classification'[GLAccount] >= 70000 && 'Cost Classification'[GLAccount] <= 70292, "CONSUMABLES",
IF('Cost Classification'[GLAccount] >= 70300 && 'Cost Classification'[GLAccount] <= 70390, "PERSONNEL",
IF('Cost Classification'[GLAccount] >= 70400 && 'Cost Classification'[GLAccount] <= 70490, "WELFARE",
IF('Cost Classification'[GLAccount] >= 70500 && 'Cost Classification'[GLAccount] <= 70590, "TRANSPORT",
IF('Cost Classification'[GLAccount] >= 70600 && 'Cost Classification'[GLAccount] <= 70703, "PERSONNEL",
IF('Cost Classification'[GLAccount] >= 70800 && 'Cost Classification'[GLAccount] <= 70822, "DIRECT CONTRACT",
IF('Cost Classification'[GLAccount] >= 70900 && 'Cost Classification'[GLAccount] <= 70990, "EQUIPMENT",
IF('Cost Classification'[GLAccount] >= 71000 && 'Cost Classification'[GLAccount] <= 71190, "PERSONNEL",
IF('Cost Classification'[GLAccount] >= 72100 && 'Cost Classification'[GLAccount] <= 72190, "DIRECT 3RD PARTY COST"
))))))))))
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    Anonymous 

     

    if [GLAccount] >= 0 and [GLAccount] <= 49415 then "BLANK" else 
if [GLAccount] >= 70000 and [GLAccount] <= 70292 then "CONSUMABLES" else
if [GLAccount] >= 70300 and [GLAccount] <= 70390 then "PERSONNEL" else
if [GLAccount] >= 70400 and [GLAccount] <= 70490 then "WELFARE" else
if [GLAccount] >= 70500 and [GLAccount] <= 70590 then "TRANSPORT" else
if [GLAccount] >= 70600 and [GLAccount] <= 70703 then "PERSONNEL" else
if [GLAccount] >= 70800 and [GLAccount] <= 70822 then "DIRECT CONTRACT" else
if [GLAccount] >= 70900 and [GLAccount] <= 70990 then "EQUIPMENT" else
if [GLAccount] >= 71000 and [GLAccount] <= 71190 then "PERSONNEL" else
if [GLAccount] >= 72100 and [GLAccount] <= 72190 then "DIRECT 3RD PARTY COST" else "Else value"

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Anonymous 

     

    if [GLAccount] >= 0 and [GLAccount] <= 49415 then "BLANK" else 
if [GLAccount] >= 70000 and [GLAccount] <= 70292 then "CONSUMABLES" else
if [GLAccount] >= 70300 and [GLAccount] <= 70390 then "PERSONNEL" else
if [GLAccount] >= 70400 and [GLAccount] <= 70490 then "WELFARE" else
if [GLAccount] >= 70500 and [GLAccount] <= 70590 then "TRANSPORT" else
if [GLAccount] >= 70600 and [GLAccount] <= 70703 then "PERSONNEL" else
if [GLAccount] >= 70800 and [GLAccount] <= 70822 then "DIRECT CONTRACT" else
if [GLAccount] >= 70900 and [GLAccount] <= 70990 then "EQUIPMENT" else
if [GLAccount] >= 71000 and [GLAccount] <= 71190 then "PERSONNEL" else
if [GLAccount] >= 72100 and [GLAccount] <= 72190 then "DIRECT 3RD PARTY COST" else "Else value"