Text formula

[timward10]

Hi, 

I have a text formula that I would use in Excel, however PBI doesn't seem to accept this. I changed it to ISTEXT but you can only use that once, not twice. 

= if([Customer Requested Install Date]=blank(),text(EDATE([Close Date],3),"mmm YY"),text([Customer Requested Install Date],"mmm yy"))

The syntax for '(' is incorrect. (DAX(if([Customer Requested Install Date]=blank(),text(EDATE([Close Date],3),"mmm YY"),text([Customer Requested Install Date],"mmm yy")))).

Can anyone help please? 

Thanks

[Bibiano_Geraldo · Accepted solution]

Hi @timward10 ,
Power BI use the FORMAT function for this purpose. Additionally, to check for blanks, you use BLANK() or ISBLANK() instead of =blank().

Corrected DAX formula:

Install Date =
IF(
    ISBLANK([Customer Requested Install Date]),
    FORMAT(EDATE([Close Date], 3), "MMM YY"),
    FORMAT([Customer Requested Install Date], "MMM YY")
)

[timward10]

Perfect, thanks @Bibiano_Geraldo, great tip on the blanks too. 

Thanks again.