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])
m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi,
for this kind of thing, it is better to do it in Power Query, why do you need to do it in DAX?

What's the problem with your Power Query approach?

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

I am not familiar with Power Query. I was running into so many errors. That is the issue.  Thank you so much