Solved: Row Count based on month

Anonymous · ‎06-23-2020

I have following table

I need it to be like

Can someone help me achieving this?

mahoneypat · ‎06-23-2020

Yes. In the query editor, select your month column, hit the Group By button in the ribbon on the Home tab, then choose Count as the aggregation.

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

mahoneypat · ‎06-23-2020