Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm pretty new to DAX and Power BI and I've got a probem that I need to resolve. I'm trying to get 2 things from one table.
Table, lets call it Tab1, looks like this:
I would like to create a measure to:
1. Check the earliest date when status1, status2 or status3 occurs
2. Count when one of those values (status1, status2 or status3) occurs
It should look like that:
Could you help me? 🙂
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Hi,
thanks for the solution 🙂 I have to admit that I've made a mistake when showing how I would like the resault table to look like. It's a small change, maybe you could help. I just don't want the ID 4 show in that table at all, because it dosen't have status that I want to count.
EDIT: Ok, I've got it 🙂 Just changed "0" in RETURN to BLANK().
A small tweak does the trick
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |