Flag column to filter data

[mvgust]

All,

I need to create a filter to display only records that meet the below criteria.  If an employee has adjusted their timecard for a week ending date, I only want to see the records for those employees who've made changes. Below is visual of what I'd like to achieve. 

Thank you.

[Greg_Deckler · Accepted solution]

@mvgust - 

Flag Column = 
  VAR __Name = [EmpName]
  VAR __Week = [WeekEnding]
RETURN
  IF(MAXX(FILTER(ALL('Table'),[EmpName]=__Name && [WeekEnding]=__Week),[Version])>1,TRUE(),FALSE())

Flag Measure = 
  VAR __Name = MAX([EmpName])
  VAR __Week = MAX([WeekEnding])
RETURN
  IF(MAXX(FILTER(ALL('Table'),[EmpName]=__Name && [WeekEnding]=__Week),[Version])>1,TRUE(),FALSE())

[mvgust]

Thank you @Greg_Deckler for providing me 2 different options, the column is going to work better for my scenario and it worked perfectly!

I've been struggling to learn DAX - do you have any resources to suggest?  I'm ok at very simple DAX functions but what you provided I would have never even thought of.

Thank you!

[Greg_Deckler]

@mvgust - There's an Introduction to DAX section here: https://docs.microsoft.com/en-us/power-bi/guided-learning/

Radacad has some great stuff. https://radacad.com/

If you are coming from SQL, @Phil_Seamark 's DAX book is great. I think he has a new one Pro DAX too. I haven't read that one yet but if it's from Phil, it's gold.

@MattAllington has some great DAX books

@marcorusso 's  Definitive Guide to DAX is, well, it's the gold standard. Maybe a bit theory heavy but unbeatable in terms of coverage of the DAX language.

I like my book, DAX Cookbook, as a more practical guide, not nearly so much theory as just straight-up practical DAX implementation strategies for metics, KPI's, etc. to solve real world problems.

Another great resource is the Quick Measures Gallery: https://community.powerbi.com/t5/Quick-Measures-Gallery/bd-p/QuickMeasuresGallery?sortby=kudos

A lot of my stuff ends up in there. Lots of crazy inventive DAX.

Very much depends what you are into, how you learn, etc.