cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jesenavaranjan Frequent Visitor
Frequent Visitor

YTD Help

Hi,

 

So I am trying to calculate a YTD for a given month.

 

My data looks something like this (over simplified)

 

Cost Period

2      June 2018

3      July 2019

4      April 2019

1     March 2018

 

Now, I start by selecting a period, say for example June 2018

 

I then want to calculate the YTD on the page as well, not when I use TOTALYTD as the table has filtered down to June 2018 only, the period sum matches the YTD sum and does not include March 2018.


How can I get the YTD to ignore the date filter on the table, but at the same time decide to look at the financial year of 2018 due to the fact that June 2018 is selected/

 

Many thanks!

Jese

 

 

 

 

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors