topic Re: Calculate date -1 day if has condition in time range in DAX Commands and Tips

Calculate date -1 day if has condition in time range

Pilvie — Tue, 12 Jul 2022 12:17:15 GMT

I'm a newbie for Power BI. I would like to create date column that show date -1 if time range in 00:00 - 6:00 am.
What's dax that I have to use for this?

Here's I want.

Re: Calculate date -1 day if has condition in time range

tackytechtom — Tue, 12 Jul 2022 13:43:53 GMT

Hi Pilvie ,

How about this:

Here the DAX for the calculated column:

date = INT ( [start_date] - 6 / 24 )

Do not forget to change the Data Type to Date afterwards:

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Re: Calculate date -1 day if has condition in time range

Pilvie — Tue, 12 Jul 2022 15:09:37 GMT

Great that worked!

Thank you so much.