Forum Discussion

y5famfnatudu's avatar
y5famfnatudu
Icon for Resolver I rankResolver I
3 years ago
Solved

Get records from current & previous year, when only current year selected

Hello,

 

I would appreciate it so much if you can help me here please.

I would like to select a year from a slicer, but the records from the Selected year & records from Previous year to be shown. How can I achieve something like that?

Best regards,

Simon

 

 

  • y5famfnatudu's avatar
    y5famfnatudu
    3 years ago

    Thank you so much FreemanZ 

    Unfortunately, this didn't work for me, as the Date Table is realted to Orders, and other tables in the dashboard.

    Do you think it's still possible to tweak the measure please so that it shows the selected year and the previous one? Your help is so much appreciated.

     

    Best regards,

    Simon

5 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi y5famfnatudu 

    you can try like:

    Measure =

    CALCULATE([...], EDATE(TableName[Date], -12))

     

    or if you have dedicated date table, try Time Intelligence functions, like:

    CALCULATE([...], DATEADD(TableName[Date], -1, YEAR))

    CALCULATE([...], SAMEPERIODLASTYEAR(TableName[Date]))

    and many more.

    • y5famfnatudu's avatar
      y5famfnatudu
      Icon for Resolver I rankResolver I
      3 years ago

      Hi FreemanZ ,

       

      But I don't need measures to calculate anything, I just need a table visual to show the records belonging to the selected year & previous year, as shown in the screenshot above.

       

      Thank you,

      Simon

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper User
        3 years ago

        hi y5famfnatudu 

        supposing you have two unrelated tables like:

         

        1) plot a table visual with all the columns from the first table, choose "don't summarize" for every column. 

        2) write a measure like:

         

        YearFilter = 
VAR _year = SELECTEDVALUE(Year[Year])
RETURN
IF(
    YEAR(MAX(TableName[OrderDate])) IN {_year, _year-1},
    1,0
 )

         

        3) feed the measure to the filter pane for the table visual and choose 1

         

        it worked like this: