cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkS Member
Member

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

Hi @love,

I see that you now have a solution.  

With the suggestion that I provided the Source step should have been changed to  

 

Source=Query1,

 

the (Json.Document ....) should be deleted

Super User
Super User

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

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 Regular Visitor
Regular Visitor

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

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.