Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SamePeriodLastYear() - Visual Level Filters

When Slicing by a Year, my table shows the previous Year Value using the SAMEPERIODLASTYEAR function (MeasureSPLY). I then want to use the Visual Level Filters, but the value shown in the tabl...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous

First, you should know that SamePeriodLastYear is corresponding to current row context.

If there are other years in your date table, it will return SamePeriodLastYear of each of them.

For example:

current year - SamePeriodLastYear

2020            - 2019

2019            - 2018

2018            - 2017

...

And from your screen, there is no value in 2018 for [measure],

so for SamePeriodLastYear of 2019, there is no value of [measureSPLY]

 

BTW: you need to learn about row context of DAX, It may help you understand it well.

 

Best Regards,

Lin

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Many thanks for the response. I can't seem to upload photos, even though I'm signed in?? My data looks like this and has a measure value for each year: Date DimensionA DimensionB Measure1 01 January 2018 A2018 B2018 10 01 January 2019 A2019 B2019 20 01 January 2020 A2020 B2020 30 This appears to only work when Cross filter direction is set to Single. When I select 2020 from the slicer, my tables shows as expected the previous year values for 2019. This is because SAMEPERIODLASTYEAR is used in the measure MeasureSPLY. Date DimensionA DimensionB MeasureSPLY 01/01/2019 00:00 A2019 B2019 20 My question is, if I want to filter this further using Visual Filters, is there anyway to see the previous Year values shown in the table? Since the only values available in the Visual Filter are the 2020 values? Hope this makes sense. Many thanks
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Many thanks for the response. I can't seem to upload photos, even though I'm signed in?? My data looks like this and has a measure value for each year: Date DimensionA DimensionB Measure1 01 January 2018 A2018 B2018 10 01 January 2019 A2019 B2019 20 01 January 2020 A2020 B2020 30 This appears to only work when Cross filter direction is set to Single. When I select 2020 from the slicer, my tables shows as expected the previous year values for 2019. This is because SAMEPERIODLASTYEAR is used in the measure MeasureSPLY. Date DimensionA DimensionB MeasureSPLY 01/01/2019 00:00 A2019 B2019 20 My question is, if I want to filter this further using Visual Filters, is there anyway to see the previous Year values shown in the table? Since the only values available in the Visual Filter are the 2020 values? Hope this makes sense. Many thanks
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I'll try again... This time on IE which allows me to upload photos, when Chrome and Edge don't?

       

      Anyway,  many thanks for the response.

       

      My data looks like this and has a measure value for each year:

       

       

      This appears to only work when Cross filter direction is set to Single.

       

       

      When I select 2020 from the slicer, my tables shows as expected the previous year values for 2019. This is because SAMEPERIODLASTYEAR is used in the measure MeasureSPLY.

      My question is, if I want to filter this further using Visual Filters, is there anyway to see the previous Year values shown in the table?

       

      Since the only values available in the Visual Filter are the 2020 values?

       

       

       

       

      Hope this makes sense.

       

      Many thanks