Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |