Writing a measure to filter dates greater than TODAY()

[Anonymous]

I have a table containing dates ranging from 1st Jan 2018 ro 31st Dec 2021. I want to write a measure which will filter the table and return all the dates greater than TODAY(). I want to plot a graph against all the upcoming dates in the future.
Is there a way I can do this?
I don't want to use a slicer.

[pranit828]

Hi @Anonymous 

I wouldn't use a slicer neither a measure. I will filter it as below.

[V-pazhen-msft · Accepted solution]

@Anonymous 
There are a few way to write that dax, you can create a measure or a calculate column. Try:

Measure = Calculate(sum([Date]),Filter(All(Table), [Date]>Today()))
OR
Column = IF([Date]>TODAY(),[Date],BLANK())

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , better to use relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 As a slicer or at visual or page level filter.

 measure can group data into one row

Like

measure =
var _max = today()
return
CALCULATE(
COUNT ('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Date] <= _max))

or

measure =
var _max = today()
return
CALCULATE(
COUNT ('Table'[Value]),FILTER(('Table'),'Table'[Date] <= _max))

Also, refer to this video

https://www.youtube.com/watch?v=duMSovyosXE

[amaleranda]

@Anonymous ,

Try using below measure

GreaterThanToday =

VAR Result = IF(TODAY() > MAX(Calender[Date]), "Past Day", "Future Day")

RETURN

Result

it works better if you have a calander tabel in your data model