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

It looks like you're in the query editor. The query editor does not use the DAX language. You need to learn the power query language. https://msdn.microsoft.com/en-us/library/mt211003.aspx

 

The syntax for an if statement in Power Query is "if <condition> then <result> else <result>". The language is case sensitive.