Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Add Custom columm problem

IF([Status]= "sold", TEXT([Days to Contract]+[Listing Date],"mmmm-yyyy"), "00")   When I use this DAX formula it working prefectly in Excel.   But when I use this in Power BI it give me error mes...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    In Power BI Desktop Report view, right-click your table and select “New Column”, then apply the following DAX.

    NewColumn = IF(Table1[Status]="sold",FORMAT( Table1[Days to Contract]+Table1[Listing Date],"mmmm-yyyy"),"00")



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

In Power BI Desktop Report view, right-click your table and select “New Column”, then apply the following DAX.

NewColumn = IF(Table1[Status]="sold",FORMAT( Table1[Days to Contract]+Table1[Listing Date],"mmmm-yyyy"),"00")



Thanks,
Lydia Zhang