Forum Discussion

rui_silva's avatar
rui_silva
Helper I
8 years ago
Solved

Compare 2 months using Slicer

Hi, i have a table where i need to compare values from 2 months using slicer, at this moment im using this measure: Total LM = CALCULATE([nStudents];PREVIOUSMONTH('Month'[Data]) ) when i try to use...
Need Help
  • rui_silva's avatar
    rui_silva
    8 years ago

    Greg_Deckler Thanks for all the help,

    I managed to get solution using a invoked table with dates from 01/01/2018 to 31/12/2018 and its working as i would understand everytime i need to compares dates i cant uses tables i used from myself and need to create a invoked table with dates , etc 

    Thanks ! 

    Rui Silva

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

So, the sample data you presented, is that what you want to display as far as the Total LM, but you are not getting that result?

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      OK, so is the sample data presented (other than Total LM) represent your source data or are there some calculations going on there? So do you have 1 row for each month in your source data?

      • rui_silva's avatar
        rui_silva
        Helper I
        8 years ago

        Greg_Deckler So in my source data i have for each class 4 rows with diferent data and month as for example:

        IDMonth IDClass ClassName        nStudents

        1               CA       ClassA                      30

        1               CB        ClassB                      30

        2              CA          ClassA                     25

        2               CB          ClassB                    25

        3              CA         ClassA                     25

        3               CB         ClassB                     20

        4               CA          ClassA                    25 

        4               CB         ClassB                      19

         

        This is my source data the only calculation i had was the total os nStudents, and when i try to compare the months each others  when i put the measure in the table the result dont appear, Also i have Month table as Source

        IDMonth        MonthName        Date

        1                          January            01/01/2018

        2                           February          01/02/2018

        3                          March               01/03/2018

        4                           April                 01/04/2018

         

        My date column is formated to be the data table so i could compare the months.