Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.