Count all dates in the column that is less than or equal to the current month

[SirD]

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

[Nathaniel_C]

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

[Nathaniel_C · Accepted 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

[Nathaniel_C]

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

[RemyO]

Why not create a column MMM-yy

Then take that column and do a count(Workshop)