Forum Discussion
BO values to PBI values
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.
Hi Anonymous
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/
2 Replies
- tackytechtom
Most Valuable Professional
Hi Anonymous
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/