Monthly Sales Report with YTD , Last Year YTD and Budget YTD

[fairooset]

Hi,

I have two tables one Actual Data Table and another one Budgeted Data Table. I want to create a matrix table same Like below 

Actual Data Table

Budgeted Data Table

Required Matrix Table

January 2021	February 2021	March 2021	YTD	YTD LY	YTD Budget	Var. YTD Vs LY YTD	Var. YTD Vs Budget YTD
232.00	251.00	214.00	697.00	450	496	247.00	450.00

Please help @v-alq-msft 

[amitchandak]

@fairooset , You are lloking for Hybrid Table that is not possible, Check the workaround and idea

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

For time intelligence , use a date table

Refer

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

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 :radacad sqlbi My Video Series Appreciate your Kudos.