Solved: Re: Relative DAX date filter

Anonymous · ‎09-18-2020

Hi

This is most likely extremely easy but I have not found a solution for this yet. I need to config my date slicer to start from 31/08/2020 until TODAY. I tried DATESBETWEEN function but that's not working for me:

Relative date = DATESBETWEEN('mee v_MasterData_Dates'[date_bkey], 31/08/2020, TODAY())

amitchandak · ‎09-18-2020

@Anonymous , Typically you have to create a flag like this and use

if( [Date] >=eomonth(today(),-1) && [Date] <= today(),1,0)

or

if( [Date] >=date(2020,08,31) && [Date] <= today(),1,0)

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎09-18-2020

@Anonymous , Typically you have to create a flag like this and use

if( [Date] >=eomonth(today(),-1) && [Date] <= today(),1,0)

or

if( [Date] >=date(2020,08,31) && [Date] <= today(),1,0)

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Relative DAX date filter

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly