Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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. 🙂
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |