Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I would only like the value in 'Beoordeling' to be counted when 'Startdatum' is Max.
'Gevolmachtigde', 'Combitaak' and 'Jaar' should be unique.
So in this example, only the bold values should be counted.
If 'Gevolmachtigde', 'Combitaak' or 'Jaar' changes, again the Max value of 'Startdatum' should be calculated and the value of 'Beoordeling' should be counted.
Gevolmachtigde | Combitaak | Jaar | Startdatum | Beoordeling |
A | ACC-6 | 2020 | 1-3-2020 | Goed |
A | ACC-6 | 2020 | 1-6-2020 | Goed |
A | ACC-6 | 2020 | 1-9-2020 | Goed |
A | ACC-6 | 2020 | 1-12-2020 | Goed |
B | ACC-6 | 2020 | 1-3-2020 | Goed |
B | ACC-6 | 2020 | 1-6-2020 | Goed |
B | ACC-6 | 2020 | 1-9-2020 | Goed |
B | ACC-6 | 2020 | 1-12-2020 | Goed |
Hope this is clear. Thanks in advance.
Solved! Go to Solution.
Hi @Frunkle93 ,
Try the following code:
Calculate =
Var MaximumDate = MAX('Table'[Startdatum])
Return
CALCULATE( COUNT('Table'[Beoordeling]),'Table'[Startdatum] = MaximumDate)
Based on your data the information is very reduced but has you can see I have made a change to the dataset and included a new line for B on the maximum date has you can see the result is updating
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Frunkle93 ,
Try the following code:
Calculate =
Var MaximumDate = MAX('Table'[Startdatum])
Return
CALCULATE( COUNT('Table'[Beoordeling]),'Table'[Startdatum] = MaximumDate)
Based on your data the information is very reduced but has you can see I have made a change to the dataset and included a new line for B on the maximum date has you can see the result is updating
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
73 | |
69 | |
36 | |
26 | |
24 |
User | Count |
---|---|
97 | |
92 | |
54 | |
45 | |
41 |