Forum Discussion
Solved
I need help
Hello! I have a database containing student enrolments, the dates of which range from June to October 2021 and May to July 2022. To do this, I need to calculate the accumulated of these registrati...
Hi Syndicate_Admin ,
1 create a model like the following( add a calendar table for the fact table):
2 create a measure via:
Measure = calculate(DISTINCTCOUNT('Fact table'[id]), DATESYTD('calendar'[Date]))Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Syndicate_Admin ,
1 create a model like the following( add a calendar table for the fact table):
2 create a measure via:
Measure =
calculate(DISTINCTCOUNT('Fact table'[id]), DATESYTD('calendar'[Date]))
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.