Forum Discussion
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
Community Champion
Community ChampionHi Kosta88 ,
Use one of the filters in the conditional column (I used 2) to see the syntax, then add the rest of the conditions to the formula bar. You will have to use "and" and "or". Note that the key words are all lower case, and you have to write out "then" and "else."
Finally you will need to filter the table based on your new column.
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