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