Forum Discussion

jharv9's avatar
jharv9
Frequent Visitor
9 years ago
Solved

Dynamic Year To Year Comparison

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 nu...
General Comment
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    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.

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi There,

 

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

 

 

Thanks & Regards,

Bhavesh

jharv9's avatar
jharv9
Frequent Visitor
9 years ago

I posted the direction I've being going above.

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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    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.