Show table numbers until selected date

[Anonymous]

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












For example, here i selected january,february and march to show user A,B,C. Can i have this same result just selecting March?? (for this project it was required to use a table visual). Something like "Select * from table where Date<="2020/03/01" "

 

[v-lili6-msft · Accepted solution]

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

[Anonymous]

Thats it!!! it worked, thank you so much @v-lili6-msft 

[amitchandak]

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

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.