Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I’m trying to solve a problem in Power BI with the following dataset structure:
I need to calculate the number of events for each unique service type entry, based on the following logic:
Thanks in advance!
Solved! Go to Solution.
For Serv 1 (No 1):
should that be start date < 1/6/2025? it's because if <= , then we will get 6 rows
pls see the attachment below
Proud to be a Super User!
For Serv 1 (No 1):
should that be start date < 1/6/2025? it's because if <= , then we will get 6 rows
pls see the attachment below
Proud to be a Super User!
Great ,
the start date for Serv 1 (No 1) is >= 1/1/2025
sorry for the mistake
I ll will test this on my data set 🙂
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |