How create greater than from calendar date picker

[Anonymous]

I am trying to create a date filter that filters data like this (Finish_Date >= value selected), meaning that if a user selected today's date, they will get a results for today's date and beyond , it will look ahead. Additionally  the second filter should do the opposite, when the user select todays date, they get the data for today and all the previous days (Start_Date <= value selected). Does anyone know how to create such a filter?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Sample data:

Create a new date table.

Date = CALENDARAUTO()

Measure:

Measure1 = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('Date'[Date]),1,0)

Measure2 = IF(SELECTEDVALUE('Table'[Date])<=SELECTEDVALUE('Date'[Date]),1,0)

Put measure separately in the filter of the corresponding view and set equal to 1.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I needed to be able to use this new column as a date filter in the report builder but the results you are showing are in Power BI, would you be kind enoughto point me to the workaround on this?

[sevenhills]

Check this and see if it can be fit to your requirement

https://radacad.com/power-bi-from-and-to-date-filtering-with-one-slicer

https://www.spguides.com/power-bi-filter-between-two-dates/