Forum Discussion
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??
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" "
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
4 Replies
v-lili6-msftCommunity Support
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
Thats it!!! it worked, thank you so much v-lili6-msft
- amitchandak
Super User
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))
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.
