Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So in my table i have a an order date, a deliver date and a custom collumn for today's date. I have set up a column using
"DeliveryDays = (TableName[OrderDate] - TableName[ReceivedDate])*1." which is giving me the days an order took to deliver.
But I also need to show how many days it has been if the order has not been delivered. so I need something like: Subtract delivery date from order date, if delivery date is blank then subtract today's date from order date.
I appreciate the help.
Solved! Go to Solution.
you can do something like this, didn' tested it but this will do.
Time to Deliver = DATEDIFF(Table[Order Date], IF(Table[Delivery Date] = BLANK(), TODAY(), Table[Delivery Date], DAY)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @RobertW3,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
you can do something like this, didn' tested it but this will do.
Time to Deliver = DATEDIFF(Table[Order Date], IF(Table[Delivery Date] = BLANK(), TODAY(), Table[Delivery Date], DAY)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |