Forum Discussion
Filter rows based on dates comparison
Create measure
Measure =
var max_start=calculate(max(table[STOCK_START_DATE]),all(table))
return
if(max(table[STOCK_END_DATE])<max_start,1,-1)
And then add this measure to your visual level filter and set it to 1.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Hi Anonymous ,
thank you very much for your answer!
I've set the measure that you suggested but I can't add it as a filter: when I drag and drop the measure to the filters nothing happens, as if this measured could not been accepted as a filter....
First drag table visual and in table visual drag required column.
then create the measure which i have suggested.
Add it to visual level filter(not page level filter) ans click on "is" and set it to 1 and then click on apply filters.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Sorry but I didn't understand what you mean by:
Anonymous wrote:First drag table visual and in table visual drag required column.
Can you explain me with more details?
Thanks again!
There is visualization section.
Select table visual.
Then drag required fields in table visual.
and drag measure to visual level filter.
Thanks, it works!