Solved: Dynamic Year To Year Comparison

jharv9 · ‎09-13-2016

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?

Eric_Zhang · ‎09-14-2016

@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.

View solution in original post

BhaveshPatel · ‎09-14-2016

Hi There,

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

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

jharv9 · ‎09-14-2016

I posted the direction I've being going above.

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

Eric_Zhang · ‎09-14-2016

@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.