Forum Discussion

timward10's avatar
timward10
Helper II
1 year ago
Solved

Text formula

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

 
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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")
)

2 Replies

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    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")
)