previous month by category

[Anonymous]

Hi,

I am trying to create a table like below in power BI and subsequently create a waterfall chart but not sure how:

Group	Retail	Corporate
Month	Total per month	PY month	%	Total per month	PY month	%
Jan-18	250			140
Feb-18	550	250	300%	100	140	-40%

But my datasets is as follows:

Month	Customer	Amount	Group
Jan-18	A	100	Retail
Jan-18	B	150	Retail
Jan-18	C	140	Corporate
Feb-18	A	250	Retail
Feb-18	B	300	Retail
Feb-18	C	100	Corporate

Appreciate it if someone could help on this. Thanks

[mwegener · Accepted solution]

Hi @Anonymous 

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

It worked.

Thanks alot @mwegener.