cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mecasteel
Regular Visitor

Compare two columns and filters

I would like to use DAX to compare [SiteID] of the same [AsOfDate] and [CustomerPartNo] and add the [LastUsedDate] to the opposite [SiteID].  After creating the two new columns and adding [LastUsedDate] to each, I’m at a lost on how to proceed. I hope someone would know the best way to do this.  Below is sample output.

 

AsOfDate

SiteID

CustomerPartNo

LastUsedDate

MC LastDate Used

SC LastDate Used

8/2/21

SC

00309SR37010

7/27/21

7/26/21

7/27/21

8/2/21

MC

00309SR37010

7/26/21

7/26/21

7/27/21

8/2/21

SC

95060XC30009

7/22/21

7/21/21

7/22/21

8/2/21

MC

95060XC30009

7/21/21

7/21/21

7/22/21

9/6/21

SC

95060XC30004

BLANK

8/16/21

BLANK

9/6/21

MC

95060XC30004

8/16/21

8/16/21

BLANK

 

 

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@mecasteel  please try this





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


View solution in original post

4 REPLIES 4
smpa01
Super User
Super User

@mecasteel  Can you please attach your pbix here through 1drive/gdrive?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


can't right now, traveling.

smpa01
Super User
Super User

@mecasteel  please try this





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


View solution in original post

your PBIX works great, but when i apply it to the full table - I get error 'EARLIER/EARLIEST  refers to an earlier row context which doesn't exist.'

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors