The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi ,
I need some help with DAX measure. I have sample table with different categories with Error rate for Quarter 1 and Quarter 2. I want to find distinct count of Categories where the Error rate has increased from last quarter to current quarter.
Sample Data :
Year | QTR | Category | Error Rate |
2023 | 1 | A | 20% |
2023 | 1 | B | 10% |
2023 | 1 | C | 15% |
2023 | 1 | D | 5% |
2023 | 1 | E | 10% |
2023 | 2 | A | 10% |
2023 | 2 | B | 20% |
2023 | 2 | C | 30% |
2023 | 2 | D | 10% |
2023 | 2 | E | 5% |
In above sample data Category B,C and D has error rate increased from Q1 to Q2. The expected output here would be 3.
Solved! Go to Solution.
@Vijay08V hi,
here is the DAX,
Proud to be a Super User!
A simple use case of DAX Window function.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
@Vijay08V hi,
here is the DAX,
Proud to be a Super User!