Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Select data according to certain date

Hi everyone,  I would ask for your support and knowledge to help me to solve this topic. I have a set of prices, for few contracts, launched in some dates. I need to filter all the items which its ...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous ,

 

You can create a measure like this:

 

_Filter = 
VAR _date = DATE(SELECTEDVALUE('Table'[Contract_Year]), SELECTEDVALUE('Table'[Contract_Month]),  1)
RETURN IF(_date >= DATE(2020, 10,30), 1, 0)

 

 

 

 

Use this measure to filter the visual.