Forum Discussion

bikelley's avatar
bikelley
Icon for Helper IV rankHelper IV
5 years ago
Solved

Help with converting DAX to M in most efficient way

Hello,  I have an M query that needs to changes, but I am not familiar with M.  The issue is this query relying a lot on [Region]. I want to minimize the use of this column. I want to leverage ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    bikelley Maybe:

    = Table.AddColumn(#"Replaced Value1", "Region Adj",
each if [Account.Sub_Region__c] = "iMETA" then "iMETA"
else if [Account.Region__c] = "EMEA" then "EUR"
else if Text.Contains([Region],"META") or Text.Contains([Region],"EMEA") then "EUR"
else if [Account.Region__c] = "" and [Account.Sub_Region__c] ="" then [Region]
else [Account.Region__c])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

bikelley Maybe:

= Table.AddColumn(#"Replaced Value1", "Region Adj",
each if [Account.Sub_Region__c] = "iMETA" then "iMETA"
else if [Account.Region__c] = "EMEA" then "EUR"
else if Text.Contains([Region],"META") or Text.Contains([Region],"EMEA") then "EUR"
else if [Account.Region__c] = "" and [Account.Sub_Region__c] ="" then [Region]
else [Account.Region__c])
bikelley's avatar
bikelley
Icon for Helper IV rankHelper IV
5 years ago

Greg_Deckler  Thank you so much, I think this should work, I will get back to you asap. After I check on this. Again, I truly appreciate your help.