Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show table numbers until selected date

Hey, Im trying to use a table visual, im trying to show the dates until the selected month of my filter, is it possible to do something like that without using mutiple selection?? ...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    For your requirement, you need  a separate date table for slicer.

    Try this way as below:

    Step1:

    Create a separeate date table then use it as slicer.

    Step2:

    Create a meausre as below:

    Forflag = CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[Date]<=MAX('Date'[Date])))

    Step3:

    Drag this meausre into table's visual level filter and set is not blank

    Result:

     

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Add one QTD or rolling measure and check.

 

QTD Sales = CALCULATE(countrows(Table),DATESQTD(('Date'[Date])))

Rolling 3 = CALCULATE(countrows(Table),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-3,MONTH))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey amitchandak , thanks for the reply, but its still doesn't work, i need something like "Select * from table where Date<="MONTH SLICER"", since its just a user table with the basic informations i dont have something like sales information.