Forum Discussion

NickTT's avatar
NickTT
Icon for Helper III rankHelper III
5 years ago
Solved

TOTALYTD Total in Table

DATE COUNTS COUNTS TYTD 2021-03 30 89 2021-02 28 59 2021-01 31 31 2020-12 26 323 2020-11 24 297 2020-10 42 273 2020-09 31 231 2020-08 22 200 2020-07 3...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, NickTT 

    Please try the below measure.

    The sample pbix file's link is down below.

     

     

    Counts TYTD FIX =
    SUMX( VALUES('Date'[Year]), TOTALYTD([Counts Total], 'Date'[Date]))
     
     
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.