Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Great that worked!
Thank you so much.