How to get Previous Date even if current date is blank?

[ddpl]

Data:

Product	Date
A	1-Apr
A	2-Apr
A	3-Apr
B	1-Apr
B	2-Apr
C	1-Apr

To get previous date

Pre_Dt =

CALCULATE(

    LASTNONBLANK('Table'[Date], 'Table'[Date]),

    ISAFTER('Table'[Date], MAX('Table'[Date]), DESC),

    ALLEXCEPT('Table', 'Table'[Product])

)

in Matrix I got

i need

if there is previous date even if current date is blank then show me

[Anonymous · Accepted solution]

Hi @ddpl ,

A table of dates needs to be created (no need to create a relationship). Then create the following formula that will get the blank values.

MEASURE =
IF (
    ISBLANK ( [Pre_Dt] ),
    CALCULATE ( MIN ( 'Table'[Date] ), 'Table'[rank_] = 1 ),
    [Pre_Dt]
)

Best Regards,
Adamk Kong

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