Forum Discussion

nleuck's avatar
nleuck
Post 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.

Arjunarao's avatar
Arjunarao
Resolver I
7 years ago

Hi,

Please check this.

 

Total Mtd = TOTALMTD(SUM(Sales[Sales]),Sales[Date],YEAR(Sales[Date])=YEAR(TODAY()))

Total Mtd Current Month = TOTALMTD(SUM(Sales[Sales]),Sales[Date],Month(Sales[Date])=Month(TODAY()))

Total Ytd = TOTALYTD(SUM(Sales[Sales]),Sales[Date],YEAR(Sales[Date])=YEAR(TODAY()))

 

Download:

https://drive.google.com/open?id=1HxhA3ntDvEUQOSkMJD7DqKLll2QpLhhu