Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have the below formula in Business Objects, how do i convert it in PBI?
Days for Approval (Numeric)
=DaysBetween([Created];ToDate(FormatDate([Approved Date];"MM/dd/yyyy");"MM/dd/yyyy"))
Days for Approval
=If (IsNull([Approved Date])) Then "Not Approved" Else DaysBetween([Created] ;ToDate(FormatDate([Approved Date];"MM/dd/yyyy");"MM/dd/yyyy"))
Thank you in advance.
Solved! Go to Solution.
I have not worked with BO, but I would still give it a shot:
Here the DAX for a calculated columns:
Days for Approval (Numeric) = DATEDIFF ( 'table'[Created], 'table'[Approved Date], DAY )
Days for Approval = IF ( 'table'[Approved Date] = BLANK(), "Not Approved", DATEDIFF ( 'table'[Created], 'table'[Approved Date], DAY ) )
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 |
I have not worked with BO, but I would still give it a shot:
Here the DAX for a calculated columns:
Days for Approval (Numeric) = DATEDIFF ( 'table'[Created], 'table'[Approved Date], DAY )
Days for Approval = IF ( 'table'[Approved Date] = BLANK(), "Not Approved", DATEDIFF ( 'table'[Created], 'table'[Approved Date], DAY ) )
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 |
It worked Thank you. 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |