Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rajat
Frequent Visitor

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/2015

 

 

Task allocation
TaskID Project ID Allocation Date Due date         Task status
T1        P1            20/10/2015      15/12/2015      Completed
T2        P1            25/10/2015      10/12/2015      In progress
T3        P1            23/10/2015      05/12/2015      Completed


Now I have to update Project plan status in “Project Master”on the basis of Plan Status of Task Allocation table. If any of the “Task status” is “In progress” the “Project Plan Status” is also “In progress”.

 

so please suggest me the solution.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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". 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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". 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.