Return another column value when using Parallel period

[Anonymous]

Hi

I'm sure this should be relatively easy to do but think i'm having a Monday morning brain fade!

I have 2 cards, one which shows the latest month count of staff and the other the previous month. I also have a slicer where users can pick which ever month they want and the cards update as necessary.

I'm trying to get the card titles to update dynamically too. I am able to get the latest month easily using;

SELECTEDVALUE(Date_table[Financial_Month])

However, I'm struggling with getting the value for the previous month from my date table. Using the below returns the previous month date absoluely fine, but it's the value in an adjacent column, Date_table[Financial_Month], that i would like return and use in the card title

PARALLELPERIOD(Date_table[Month_end],-1,month)

Any help greatly appreciated

[Anonymous]

Managed to solve it! 

LOOKUPVALUE(Date_table[Financial_Month], Date_table[Month_end],vPARALLELPERIOD(Date_table[Month_end],-1,month))

[andhiii079845]

Hi @Anonymous 

do you have a example file without sensitive datas?