Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
Hi
Im converting to power query , but can't find a solution to my measure.
In excel my formula for countifs work fine , but can't work it out in Power query , or if it can actually be done .
- Criteria 1 ( History New Value Start )
- Criteria 1 (<= start date)
- Criteria 2 ( History new value start)
- Criteria 2 >(end date)
- Criteria 3 History Old value)
- Criteria 3 are closed
I'm asking how to count how many times does the closed criteria appear inbtween 2 chosen dates.
Any help , would be appreciated 
Posted : 12/08/2022 4:09 am
Hi Jacqlyn,
Will this value be used in anther query? I ask because usually Power Query cleans the data and then you summarise it (count etc.) in a PivotTable or with formulas later after Closing & Loading to a Table, PivotTable or Data Model.
If you want to use Power Query, then you can use Filters to filter the data by the criteria, then Transform tab > Statistics to count values or count distinct values that are remaining.
Mynda
Posted : 12/08/2022 4:22 am
