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 Ins...
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")
)
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")
)
  • timward10's avatar
    timward10
    Helper II
    1 year ago

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

     

    Thanks again.