filter data not older than 48hrs

[Anonymous]

Hello everybody,

is there anybody who knows how to insert a measure, or editing the query to show values not older than 48hrs? I tried a combination of EACH IF and HOURS but doesn't work.

Cheers,

Andrea

[Vvelarde · Accepted solution]

@Anonymous

Hi Andrea,

You can do it in Advance Editor

Or Using the Menus

[Anonymous]

Do you also know perhaps how, in the query editor, to make appearing in a new column the value corresponding a Today()-2? 

[Vvelarde]

@Anonymous

in a custom column:

Date.AddDays(DateTime.Date(DateTime.LocalNow()),-2)

[Anonymous]

Awesome @Vvelarde!!! You made my day!!! 🙂