Dynamic Year To Year Comparison

[jharv9]

I'm trying to figure out how to compare TV ratings month to month in the tabular view. It won't only be month over month but it could be March 2015 compared to July 2016. I've tried to create this numerous time but I can't seem to two different dates to line across. Can someone please help with this?

[BhaveshPatel]

Hi There,

Please post your sample data file and requirements for the designing of the exact solution.

Thanks & Regards,

Bhavesh

[jharv9]

I posted the direction I've being going above.

The view that I am aiming for is in the excel sheet screenshot.

[Eric_Zhang · Accepted solution]

---

@jharv9 wrote:

I posted the direction I've being going above.

The view that I am aiming for is in the excel sheet screenshot.

---

In this case, you can create a program table(program = values(yourtable[programeName])) and then split the one table into two, one for History and the other for Forecast. Link split two tables to the program table via a one : one relationship(single filter direction) by the programName column. Then apply two slicer to the YearMonth of two tables.

Regarding the excel sheet screenshot, create 5 measures, eg. History = LASTDATE(HistoryTable[YearMonth]). And then put the ProgramName from program table and the 5 measures to a table visual.

[jharv9]