Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Return another column value when using Parallel period

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
 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Managed to solve it! 

     

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