Forum Discussion

FranckGbadamass's avatar
FranckGbadamass
Helper I
4 years ago
Solved

Help custom column

Hello,

I'd like to create a custom column in PowerBI with the below formula :

Trim_ContractDate = IF(DOSSIER_PA[Année_ContractDate]<>"","T" &""& FORMAT(DOSSIER_PA[Contract_Date],"Q","" ))

but it returns #error as you can see below.

DAX comparison operations do not support comparing Integer values with Text values. Use the VALUE or FORMAT function to convert one of the values.
I don't know how to fix it, any help will be appreciated.
Thanks
Need Help
Tutorial Requests
  • smpa01's avatar
    smpa01
    4 years ago

    FranckGbadamass  try this

    Trim_ContractDate=
IF (
    DOSSIER_PA[Année_ContractDate] <> BLANK (),
    "T" & ""
        & FORMAT ( DOSSIER_PA[Contract_Date], "Q", "" )
)

3 Replies