Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bbodnar
Regular Visitor

Filter by date column

‎06-24-2018 12:57 AM

Hello, community!

I'm new in power bi and I need your help 🙂

I have a table "Cash_flow", there are the columns with:

  1. flat ID,
  2. contract ID,
  3. date
  4. contract value.

One flat can have several contracts. I want to get only contracts with the latest date by one flat. 

Can anybody help me?

Thank you in advance!

Labels:
Message 1 of 5
7,433 Views
0
1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

‎06-26-2018 12:34 AM

Hi @bbodnar,

 

You can create a measure and add it in the Visual level filter if you don't want to add it in the visual. 

Measure =
VAR maxDate =
    CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[FlatID] ) )
RETURN
    IF ( MIN ( Table1[Date] ) = maxDate, 1, BLANK () )

Filter_by_date_column

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 3 of 5
7,418 Views
4 REPLIES 4
v-jiascu-msft
Employee
Employee

‎07-02-2018 06:29 AM

Hi @bbodnar,

 

Please mark the proper answers as solutions.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 5 of 5
7,368 Views
0
v-jiascu-msft
Employee
Employee

‎06-26-2018 12:34 AM

Hi @bbodnar,

 

You can create a measure and add it in the Visual level filter if you don't want to add it in the visual. 

Measure =
VAR maxDate =
    CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[FlatID] ) )
RETURN
    IF ( MIN ( Table1[Date] ) = maxDate, 1, BLANK () )

Filter_by_date_column

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 3 of 5
7,419 Views
Anonymous
Not applicable
In response to v-jiascu-msft

‎06-14-2020 10:28 AM

Hi

Is there any way to create this dynamically with respect Max Date Selected in Date Slicer. 

Message 4 of 5
5,003 Views
0
Anonymous
Not applicable

‎06-24-2018 07:17 AM

Similar question is answered here. This may help you.

 

http://community.powerbi.com/t5/Desktop/Max-Row-Based-on-Insert-Date/td-p/446426

 

Thanks
Raj

Message 2 of 5
7,411 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All