Solved: Filter by date column

bbodnar · ‎06-24-2018

Hello, community!

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

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

flat ID,
contract ID,
date
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!

v-jiascu-msft · ‎06-26-2018

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

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

v-jiascu-msft · ‎07-02-2018

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.

v-jiascu-msft · ‎06-26-2018

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

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.