Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors