Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

solving a query

Hi All,   I have a question on how to solve the problem i face.   I'm querying my data set for the date and its status, the status could be BLANK, new, in progress, in refinement or done, based o...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Yes. Perhaps you can first put down all the combination on the Excel and create a VALID map

     

    Task StartDate / Due Date / Task Status Name / IsValid / Message

     

    Then you can use this to write a proper DAX or PowerQuery. If you need help, you can share all the combinations and then I can provide you the syntax. I presonally think PowerQuery Computed Column would be the right approach for you.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes. Perhaps you can first put down all the combination on the Excel and create a VALID map

 

Task StartDate / Due Date / Task Status Name / IsValid / Message

 

Then you can use this to write a proper DAX or PowerQuery. If you need help, you can share all the combinations and then I can provide you the syntax. I presonally think PowerQuery Computed Column would be the right approach for you.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I'll try it and see what happens, thanks for the help.

     

    Jeff