Show orders placed 48 hours and older.

[TonyVardo]

Hello,

I just started working with Power BI and I managed to create my first report. I am stuck on the date/hours filter.

I'm connecting to a SQL database via Direct Query. In one of the Gauges I need to show Orders placed in the last 48 hours or older. I can't do advanced filtering because I need all the dates YTD for other tables and Gauges. The only option I see to filter is from Visual level filters (Advanced filtering "is on or before"), but I need to change that every day to keep it up to date.

Is there a DAX measure to calculate date +48 hours?

Thanks in advance.

[BalaVenuGopal]

Hi @TonyVardo ,

You add flag at sql query which will tell you orderpalced+48 is true or false.

At report level use visual filter only for the visual you need and apply flag = true for this visual filter.

Hope this will resolve you help.

Please mark as solution if this works for you

[TonyVardo]

I can't select True/False because it is a direct Query.

[BalaVenuGopal]

Hi @TonyVardo

Use Visual level filter at report level or you can create measure and use flag clumn in filter

[TonyVardo]

@BalaVenuGopal None of the visual slicers are working for Direct Query. I have been working with Microsoft tech support and after 3 days of back and forth, this is the only option they gave me:

You will have to perform the below changes:

Use the DATEDIF() function in the Dax to know the difference between print_date and Now()

Get this in hours, create a rule for greater then 48hours  using the “If” condition.

This is like asking a baby that just started walking to start running 🙂

[TonyVardo]

@BalaVenuGopal

Thank you for your tip. I have been trying to find a DAX for the measure and I haven't had any luck. Do you have any DAX formula that applied to my scenario? 

p.s. DAX Formula Compatibility in DirectQuery Mode

[parry2k]

Did you looked at relative filtering for date? That will do it. You will find this as an option when you filter on date column.

[TonyVardo]

Relative date filtering it only shows:

"is in the last" days (only 24 hours older),weeks,calendar weeks, months and so on OR 

"in this day" OR

"is in the next"