Forum Discussion

RaghdahIsmael's avatar
3 years ago
Solved

COUNTwithFILTERwithAND in power query

Hello Team,   i was trying to write and implement the below DAX in power query so i need your help on how to write that in power query.   # sales in 25 years period = CALCULATE (  COUNT('Sales'[...
  • HotChilli's avatar
    3 years ago

    A measure (if that is what it is) is evaluated according to context and you've missed that from the question.

    In general terms, I think you can filter all the conditions stated using the features provided in the column heading dropdowns in Power Query.

    After that you might use Table.RowCount or a Group By (from the interface) .  Something like that.