Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
So this might be a fairly simple question, but I have this table below
ID | Start Date | End Date | Count |
XXX1 | 01-01-2022 | 1 | |
XXX2 | 01-05-2022 | 01-08-2022 | 1 |
How do I make a visible that shows the sum of count every month, based on start and end date?
The visual should show below numbers. If no "End Date" it should keep showing the value based on the user selected period.
January | February | March | April | May | June | July | August | September | October |
1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 |
Thanks 🙂
Regards
Stefan
Solved! Go to Solution.
HI @Desauv
Thanks for reaching out to us.
please try this measure
count = COUNTX(FILTER('Table','Table'[Start Date]<=MIN('calendar'[Date]) && ('Table'[End Date]>=MAX('calendar'[Date]) || ISBLANK('Table'[End Date]))),[ID])
sample data
calendar
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
HI @Desauv
Thanks for reaching out to us.
please try this measure
count = COUNTX(FILTER('Table','Table'[Start Date]<=MIN('calendar'[Date]) && ('Table'[End Date]>=MAX('calendar'[Date]) || ISBLANK('Table'[End Date]))),[ID])
sample data
calendar
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |