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 ...
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", "" )
)
smpa01's avatar
smpa01
Community Champion
4 years ago

FranckGbadamass  try this

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