Forum Discussion

nleuck's avatar
nleuck
Icon for Post Patron rankPost Patron
7 years ago
Solved

Display current year months data

Hello,   I need some help with how to display Current YTD totals by Month. If you look at the picture I have Months as my columns. The values are a created measure using TotalYTD. But I would expec...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi nleuck 

    I can reproduce your problem.

    To slove this , create a measure

    Total Mtd = TOTALMTD(SUM(Sheet1[Value]),Sheet1[date],YEAR(Sheet1[date])=YEAR(TODAY()))
 or
Total Ytd = TOTALYTD(SUM(Sheet1[Value]),Sheet1[date],YEAR(Sheet1[date])=YEAR(TODAY()))

    (they show same results in a matrix)

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi nleuck 

I can reproduce your problem.

To slove this , create a measure

Total Mtd = TOTALMTD(SUM(Sheet1[Value]),Sheet1[date],YEAR(Sheet1[date])=YEAR(TODAY()))
 or
Total Ytd = TOTALYTD(SUM(Sheet1[Value]),Sheet1[date],YEAR(Sheet1[date])=YEAR(TODAY()))

(they show same results in a matrix)

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.