Forum Discussion

noliverte's avatar
noliverte
Helper III
6 years ago
Solved

Total previous period dynamically

Hello,   I have the following measure : Total Session LY all day = CALCULATE([Total Sessions-all];DATESBETWEEN(Calendrier[Calendar_Date];date(2019;01;01);date(2019;03;08)))))   --> It works fi...
General Comment
Need Help
Tips and Tricks
  • noliverte's avatar
    noliverte
    6 years ago

    Thanks a lot it works fine, I jest adapt your code to fit to my problem.

     

    Total Session LY all day = CALCULATE([Total Sessions-all];
    DATESBETWEEN(Calendrier[Calendar_Date];
    DATE(YEAR(TODAY())-1;1;1);
    DATE(YEAR(TODAY())-1;MONTH(TODAY());DAY(TODAY()-1))
    )
    )
     
    Have a nice day
     
    Noliverte