BO values to PBI values

[Anonymous]

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.

[tackytechtom · Accepted solution]

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/

[Anonymous]

It worked Thank you. 🙂