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.
Lets call the table name "Business Table", I need the DAX to create a measure that will count rows for each month and add it to the count of rows for the earlier months.
Workshop scheduled On |
01/10/2022 |
01/10/2022 |
01/11/2022 |
01/11/2022 |
01/11/2022 |
01/12/2022 |
01/12/2022 |
01/01/2023 |
01/01/2023 |
01/01/2023 |
01/01/2023 |
Expected Result should look like this
Oct-22 | 2 |
Nov-22 | 5 |
Dec-22 | 7 |
Jan-23 | 11 |
Solved! Go to Solution.
Hi @SirD ,
Here is the measure:
Running Total =
Var _currentDate = MAX(Workshops[Workshop Sceduled])
Var _calc = CALCULATE(Sum(Workshops[Count]),FILTER(ALL(Workshops),Workshops[Workshop Sceduled]<=_currentDate))
Return _calc
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @SirD ,
Like this?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @SirD ,
Here is the measure:
Running Total =
Var _currentDate = MAX(Workshops[Workshop Sceduled])
Var _calc = CALCULATE(Sum(Workshops[Count]),FILTER(ALL(Workshops),Workshops[Workshop Sceduled]<=_currentDate))
Return _calc
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @SirD ,
First you will need to use Groupby in Power Query and count the number of dates in each month.
Go to the Transform tab, select GROUPBY, Count the rows and you will have the table in the picture. Then add the table to Power BI and run the measure.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Why not create a column MMM-yy
Then take that column and do a count(Workshop)
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |