Forum Discussion

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
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.

nleuck

Post Patron

7 years ago

v-juanli-msft and Arjunarao

Thank you for your responses, but my biggest problem is I don't have one specific date column. I have two DateAssigned and DateCompleted. If I want to find the how many classes were completed in a month I can get two different answers depending on which column my created Month column is associated to (either DateAssigned or DateCompleted). This then has the opposite affect on a measure when I'm trying to find out the completion percentage for the current month. Unfortnately, I'm beginning to feel like this may be too complicated even though it should be straight forward calculations.

If you have any other ideas let me know.

Thanks again!