Need help to get the current year ,previous year total columns next to the months columns in matrix

[Anonymous]

Hi Everyone, Need your help to fullfill the requirment

I have  requirment like below 

Need to show the matrix  - columns as months data and also the FY totals dynamically,rows are countries  and the values are sales revenu.so need your help how to add FY totals dynamically( the FY start JAn and ends Dec)

Country	FY -19 Total	FY-20 Total	Total(Fy19 + FY20)	June-19	July 19	Aug-19	sep-19	Oct-19	N0v-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	June-20	July-20
INDIA	350	280	630	20	30	40	50	60	70	80	10	20	30	40	50	60	70
US	360	290	650	30	30	40	50	60	70	80	20	20	30	40	50	60	70

[amitchandak]

@Anonymous , if you looking for this year vs Last year vs FY, you can use datesytd with date calendar and  year end date

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
//Only year vs Year, not a level below

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

refer

https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

But if want a hybrid display, I logged a Idea, vote for that

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

[Anonymous]

@amitchandak  thank you very much for your prompt reposnea and i really appreciate your help!

 I want to add the columns FY19 ,FY20 Total (FY19+Fy20) Columns in the same Matrix tablefollowing with Month's data 

Country	FY 19 Total	FY20 Total	Total(Fy19 + FY20)	June-19	July 19	Aug-19	sep-19	Oct-19	N0v-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	June-20	July-20
INDIA	350	280	630	20	30	40	50	60	70	80	10	20	30	40	50	60	70
US	360	290	650	30	30	40	50	60	70	80	20	20	30	40	50	60	70