Forum Discussion
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'[SalesNumber]),
Filter (Sales, AND (Sales[Region]="AHG",
'Sales'[Months] >= 298 && 'Sales'[Months] <= 302)))
thanks in
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.
2 Replies
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.
Yes it's a measure, and yes i got your point i will be doing that.
thank you
