Using Year to date with a slicer

[Anonymous]

Hi,

Using a slicer i am able to show sales for a specific week. However, i also want to show Year to Date sales from start of year to the selected week in the slicer ALSO. How do i do BOTH in a multi-row card? 

Thanks,

[mwegener]

Hi @Anonymous,

do you use a date table?

Do you know the YTD Quick Measure?

If you provide a sample PBIX I could show you how to do it.

[Anonymous]

@mwegener  Thanks for your reply. Sample of the table below. I've used a slicer to select week 5 to show week 5 sales. But i want to show YTD to Week 5 too. I'm aware of the YTD intelligence function but doesnt the slicer filter to week 5 and therefore it wont show YTD to week 5?

YearPeriod YearQtr Year Week Period Qtr StartOfPeriod StartOfQtr Start of Year
2018191 2018191 201819 1 1 1 26/03/2018 26/03/2018 26/03/2018
2018191 2018191 201819 2 1 1 26/03/2018 26/03/2018 26/03/2018
2018191 2018191 201819 3 1 1 26/03/2018 26/03/2018 26/03/2018
2018191 2018191 201819 4 1 1 26/03/2018 26/03/2018 26/03/2018
2018191 2018191 201819 5 1 1 26/03/2018 26/03/2018 26/03/2018
2018192 2018191 201819 6 2 1 30/04/2018 26/03/2018 26/03/2018
2018192 2018191 201819 7 2 1 30/04/2018 26/03/2018 26/03/2018

[mwegener]

Hi @Anonymous ,

I hope this helps you.