Need current & previous details based on selection in Slicer

[arun2001mjl]

Hello All,

I have a Raw Data with Change Number, CI Number & Date in PowerBI.

Change Number as Slicer
CI Number as a CARD

When i select a Change number in Slicer, it should show me current CI number in CARD and another table with all previous Change numbers for that Particular CI.

Example:
From below table, I selected AA1 from Slicer and CI1 showing as latest CI in CARD.. But in next Table, it should show me all previous change numbers for that CI as AAA2, AAA3, AAA4 but it is showing as AAA1. How to bring previous change numbers for that CI? Can we achieve this in PowerBI?

Raw Data:

Change Number	CI Name	Date
AAA1	CI1	22-May-23
AAA2	CI1	20-May-23
AAA3	CI1	18-May-23
AAA4	CI1	16-May-23
BBB1	CI2	12-May-23
BBB2	CI2	13-May-23
BBB3	CI2	11-May-23
CCC5	CI3	16-May-23
CCC7	CI4	20-May-23
CCC9	CI5	18-May-23

Regards

Arun

[barritown · Accepted solution]

Hello @arun2001mjl,

For example, you could use another card with such a measure (I'd also advise you to set "single select" option in your slicer):

Here is the measure in plain text for convenience:

Previous Changes = 
VAR AffectedCI = VALUES ( data[CI Name] )
VAR LatestDate = MAX ( data[Date] )
RETURN CONCATENATEX ( FILTER ( ALL (data), AND ( [CI Name] IN AffectedCI, [Date] < LatestDate ) ), [Change Number], UNICHAR(10) )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian