cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mvgust
Helper III
Helper III

Flag column to filter data

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. 

 

employee flag.png

 

Thank you.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@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())

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@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())

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

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!

@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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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
Top Kudoed Authors