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
Anonymous
Not applicable

Filtered new table

Hi,

 

How can I create a summary table with :

NameStatusDate
AS11/1/2018
AS21/15/2018
AS33/7/2018
BS12/3/2018
BS24/2/2018
CS16/1/2018

 

Assuming "S3" is the final status, how can I create a new table in Power BI that filters all those records who have the final status of "S3" and only show the initial record. In this case, Name = A has the final status of S3, so we do not want to show that value. For the remining, we only want to show the initial status record (Status = S1). The O/P in the above example would be: 

 

NameStatusDate
BS12/3/2018
CS16/1/2018
1 ACCEPTED SOLUTION
2 REPLIES 2
Greg_Deckler
Super User
Super User

@Anonymous - Sounds like you want a Complex Selector, https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/td-p/1116633

 

In the first case, you would want something along the lines of:

 

Measure =
  VAR __Max = MAX('Table'[Name])
RETURN
  IF(__Max = "S3",0,1)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.