Locate Previous Transaction Date & Place

ade_kurniawan create these measures:

Previous transaction date = 
VAR _current_date = MAX(Sheet1[TRANSACTION DATE])
VAR _current_id = SELECTEDVALUE(Sheet1[ID CUSTOMER])
RETURN
CALCULATE(
    MAX(Sheet1[TRANSACTION DATE]),
    REMOVEFILTERS(Sheet1),
    Sheet1[ID CUSTOMER] = _current_id,
    Sheet1[TRANSACTION DATE] < _current_date
)


Location of Previous transaction date = 
VAR _current_date = MAX(Sheet1[TRANSACTION DATE])
VAR _current_id = SELECTEDVALUE(Sheet1[ID CUSTOMER])
VAR _previous_transaction_date = 
CALCULATE(
    MAX(Sheet1[TRANSACTION DATE]),
    REMOVEFILTERS(Sheet1),
    Sheet1[ID CUSTOMER] = _current_id,
    Sheet1[TRANSACTION DATE] < _current_date
)
RETURN
CALCULATE(
    SELECTEDVALUE(Sheet1[LOCATION]),
    REMOVEFILTERS(Sheet1),
    Sheet1[ID CUSTOMER] = _current_id,
    Sheet1[TRANSACTION DATE] = _previous_transaction_date
)

Put them next to the ones you already have in the table.
You need to also put the current transaction data in the visual for it to work. Previous need to be previous to something:

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

Showcase Report – Contoso By SpartaBI

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

SpartaBI Logo

Thanks for help SpartaBI & CNENFRNL but i have another problem :
my data is in different table & i cant use variable that hide in table : PBI separated table 

thanks