Forum Discussion

Kosta88's avatar
Kosta88
New Member
4 years ago

Convert DAX to M (Variables, conditions, Filter, in, countrows)

New= VAR NewPostcode =[Postcode] VAR testCreated =[created date] VAR testEnd = [Completion Date] VAR MidLevel =[Mid_Level_Work] RETURN COUNTROWS( FILTER(source, MidLevel IN {"one","two", "...
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Kosta88 
Where do your variables come from? Are they measures or columns? If they are measures this will not work.  If they are column headings, then this would be a conditional column in Power Query - it will allow you to do the multiple conditions.  Find this under Add Column tab.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

Kosta88's avatar
Kosta88
New Member
4 years ago

Hi Nathaniel, thank you for the promt reply.

 

 

My variables are columns headings as you mentioned.

 

I have tried to go under transform data, addcolumn , custom column but I am not sure how to convert the DAX code to Power query syntax.

 

Could you please provide a sample code that could help me please.

 

Thank you again.

 

Kosta