cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike_Mace
Resolver I
Resolver I

Date greater than other date issue

Hi Forum,

 

Item lists A&B have common entries and I created a relationship between them.

I need to identify the common entries where date A comes is a later date to B

 
I thought this would be a straight forward one with following Dax, but the calculated result is only "no issue". I checked, there are definitely cases where date A are greater than date B while others are smaller. The calculation should find both issue & no issue
file on wetransfer link
 
date comparison = IF('A schedule'[date A].[Date] > 'A schedule'[date A].[Date],"issue","no issue")
 
 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Mike_Mace , Create a new column in A schedule like

 

if('A schedule'[date A] < minx(filter('B schedule', 'A schedule'[Item List A] = 'B schedule'[Item List B] ),'B schedule'[date B]) ,"Yes", "No")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Mike_Mace , Create a new column in A schedule like

 

if('A schedule'[date A] < minx(filter('B schedule', 'A schedule'[Item List A] = 'B schedule'[Item List B] ),'B schedule'[date B]) ,"Yes", "No")

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors