Summarize colums by year, client, and revenue stream and then variance year over year

[Kitkat]

Hi Team,

 I have succesfully created a table using this formula:

Total Client by Stream = SUMMARIZECOLUMNS('Consolidated Details'[Client Name],'Consolidated Details'[Revenue Stream],"Total Revenue",SUM('Consolidated Details'[Total Revenue]))

What i need to do is add in the year from a Related Table, as the dates in "Consolidated Details" do line up with my Fiscal year.

Then i want to do a % of change by Client/Revenue stream ( I imagine i can do this using a quick measure of YOY)

Your suggestions and help is greatly appreciated

Sincerely,

Kat

[v-huizhn-msft]

Hi @Kitkat,

Please refer to this following similar thread.

https://community.powerbi.com/t5/Desktop/Calculating-percent-change-compared-to-last-year/td-p/15294...

Best Regards,
Angelia