cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Calculate Group By Month

Hi,

I have to write a DAX formula to calculate no of "Yes" group by Month

My data looks something like this:

All i am after is calculating No of yes values per Month.

I am currently using =

countG1 = CALCULATE(COUNT(TableName[ColumnName]), FILTER(ALL(TableName), TableName[ColumnName]="Yes"))

This gives me sum Total for the table, (Total Yes = 13)

I wanted to see per month total.

July 2019- 1

Oct 2019 - 2

Nov 2019 - 1

Dec 2019 - 1

Any help will be appreciated,

Thank you!!

Kind Regards

2 REPLIES 2
Anonymous
Not applicable
``````// All you have to do is to have
// a measure that returns the number
// of Yes'es in any selection. Then,
// to get the number of Yes'es by month
// you just slice by months. Please make
// sure you have a column with months
// by which you can slice.

[# Yes] =
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Yes/No] = "Yes" )
)``````
Super User

@Anonymous , Create a date table, these you have month year, so that you can analyze by month

Use a fomula like

countG1 = CALCULATE(COUNT(TableName[ColumnName]), FILTER(TableName, TableName[ColumnName]="Yes"))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors