Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Countifs equivalent matching variable criteria

Hi, I've had a search and found some countifs solutions for powerBI but none that I can see that are a solution to my  goal so I'm hoping that somone could share a possible solution.   Summary: I n...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , a new column like

    if([Date] < minx(filter(Table,[HostOrderId]  =earlier([HostOrderId]) ),[Date]) , True(), false() )

     

    or

     

    if([Date]<= minx(filter(Table,[HostOrderId]  =earlier([HostOrderId]) ),[Date]) , True(), false() )

     

    Change as per need

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , a new column like

if([Date] < minx(filter(Table,[HostOrderId]  =earlier([HostOrderId]) ),[Date]) , True(), false() )

 

or

 

if([Date]<= minx(filter(Table,[HostOrderId]  =earlier([HostOrderId]) ),[Date]) , True(), false() )

 

Change as per need