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

rui_silva's avatar
rui_silva
Helper I
8 years ago

Greg_Deckler  First of all Thanks for  the assistance,

About true Date Column what u mean with that ? 

Its is a column made with Dax / Power Query ?

 

rui_silva's avatar
rui_silva
Helper I
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