Forum Discussion

Rajat's avatar
Rajat
Frequent Visitor
10 years ago
Solved

use text type column in DAX

The scenario is Project Master Project ID       Project Name     Start date     End Date      Expected end date          Project Plan Status 1                         A                   23/05/201...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Well, first you would have to relate your tables to one another so you will need to create a new column that concatenates the Project ID in Master with a P prefix. Relate tables. Then, you can try having Project Plan Status be a calculated column that uses IFERROR and SEARCH and feed it Task status, have it look for "In progress". If it errors, set "Completed", otherwise set "In progress". 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Well, first you would have to relate your tables to one another so you will need to create a new column that concatenates the Project ID in Master with a P prefix. Relate tables. Then, you can try having Project Plan Status be a calculated column that uses IFERROR and SEARCH and feed it Task status, have it look for "In progress". If it errors, set "Completed", otherwise set "In progress".