cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## date slicer last date

Hi all,

I have found multiple post on the default date slicers but I cannot pinpoint the proper example.

I have a date slice where I want the end date to be today minus 6 months.

Ex  beginning is 01/01/2014 and last date would be defaulted to today - 180 days.

Users can also change the last date afterward to whatever they need.

Is there a quick way to do this??

I have tried all options but I cannot do it properly.

Thanks

Francois

1 ACCEPTED SOLUTION
Community Support

Hi @francoisl ,

There are two ways you could try.

• Create a measure
``Measure = IF(MAX('Table'[Date]) <= TODAY()-180,1,0)``

• Or you could create a new date table and use it as slicer.
``Table 2 = CALENDAR(DATE(2019,1,1),TODAY()-180)``

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support

Hi @francoisl ,

There are two ways you could try.

• Create a measure
``Measure = IF(MAX('Table'[Date]) <= TODAY()-180,1,0)``

• Or you could create a new date table and use it as slicer.
``Table 2 = CALENDAR(DATE(2019,1,1),TODAY()-180)``

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

@francoisl , this is a bit tricky in power bi. You need to create flag

Last Date = if('Date'[Date]=TODAY()-180 ,"Last Date",[Date]&"")

Sort this on Your date and use the filter on Last Date.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.