How to get report to show if a date is past another date?

[Anonymous]

HI, 

I was wondering how i could get my powerbi to show only values if they are past another date: 

ie. only show values if Estimated delivery date is greater than customer required date

[Anonymous]

thank you!

What is the customer required date is blank? As sometimes I dont have a date and wont want it showing up in the report.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I think you can create another measure. Here is the DAX code.

Measure 2 = IF('Table'[Measure]="Over",BLANK(),'Table'[Measure])

Then you will get the "In" state and you will not see the "Over" state.

Best Regards

Yilong Zhou

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

[Anonymous]

Hi  @Anonymous ,

Your solution is great, @amitchandak. It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I create a table as you mentioned.

Then I create a measure and get what you want.

Measure =
IF (
    MIN ( 'Table'[Estimated Delivery Date] )
        > MIN ( 'Table'[Customer Required Date] ),
    "Over",
    "In"
)

Best Regards

Yilong Zhou

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

[amitchandak]

@Anonymous , you can create a measure and use that in the visual or visual-level filter

calculate(Sum(Table[Value]), filter(Table, Table[Estimated delivery] > Table[customer required date] ) )