Forum Discussion

love's avatar
love
Helper I
8 years ago
Solved

Returning a boolean value via Power Query M with data from multiple columns

 Hello.   I would like a custom column to return a boolean value depending on the data in other columns.   Example: If all "statuses" from one "milestone" are either "done" or "Dropped" the costu...
  • love's avatar
    love
    8 years ago

    Hello.

     

    Thank you for your reply MarcelBeug.

     

    I ended up finding an alternative solution. I was able to query for additional fields in my base query, one of which was an indicator for completion which makes my initial problem irrelevant and seems like the overall more elegant solution.

     

    I will try to check out your proposal at a later stage out of curiousity.

     

    Thanks again everybody.

    -l

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi love,

 

This calculated column formula works

 

=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Milestone]=EARLIER(Table1[Milestone])&&(Table1[Status]="Done"||Table1[Status]="Dropped")))=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Milestone]=EARLIER(Table1[Milestone])))

 

Hope this helps.

love's avatar
love
Helper I
8 years ago

Thanks MarkS and Ashish_Mathur for the follow up. Your answers helped me understanding the errors I made and are a great help for future projects.