overall status in the table via power query

[Anonymous]

How to get the overall status in powerbi/powerquery?

the overall status will be "On Track" if it's not drill down based from the multiple status of Main.

is this possible?
thank you!

[BA_Pete]

Hi @Anonymous ,

You need to define the logic for displaying "On Track" at the Main level. I assume if all Child values are "Not Started", for example, you're not going to want it to say "On Track".

Once you've defined the logic, you would create a new Status measure that contextually evaluates the logic and outputs the Status text that you want at each level.

Pete

[Anonymous]

Thank you @BA_Pete  for the response.

Can you please provide sample of measure?

if Child 1-Completed, Child 2-Ongoing, Child 3 - Started = On Track

if Child 1-Overdue, Child 2-Overdue, Child 2- Ongoing = Overdue

Thanks