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", "...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Kosta88 ,

You can first use the if function to determine whether [MidLevel] contains {one,two,three} and [Postcode]=current [Postcode], etc.

if List.Contains({"one","two", "three"},[MidLevel])
then 1
else 0

In grouping to accumulate counts based on conditions:

Grouped Running Totals in Power Query • My Online Training Hub

Solved: Cumulative sum in Power query editor - Microsoft Power BI Community

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.