Column to Show Percentages of Months

[barrymcguigan84]

I would like to create a column in my data that showed the % of a particular value for each month.  

So the output would be like this, with the MonthY% being the calculated one.  It would calculate the % of Y's in January and the populate every row with January in the month column with the resust.  

What formula would I need for this calculated column?

[rsbin · Accepted solution]

@barrymcguigan84 ,

I think this is what you are after:

MonthY% = 
VAR _Month = [Month]
VAR _Yes = CALCULATE( COUNTA([Y/N]), FILTER( YesNo, YesNo[Month] = _Month && [Y/N] = "Y" ))  //Count the Y's
VAR _COUNT = CALCULATE( COUNTA([Y/N]), FILTER( YesNo, YesNo[Month] = _Month ))  //Count all Responses
VAR _Result = DIVIDE( _Yes, _COUNT, 0)

RETURN
     _Result

In the future, please post sample data as a table, not an image.  Easier for folks to copy the data to help.

Hope this is the result you are looking for.

Regards,

[barrymcguigan84]

This has worked perfectly, thank you.