Forum Discussion
SCNCKS1
Helper I
Helper Ifind a value based on 2 cells within a range
Hi - I hope someone can help, I have the following data and I need to dynamically return the rate associated with the rate_type and year/quarter. Dynamically, the date will continue to grow both on t...
Hן SCNCKS1
In order to connect the tables, you need to convert your rates table into a longitudinal table first.
Using unpivot in PQ :After this your rates table will look as on pict :
From this stage ypu can just merge it based on item and quarter :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ritaf1983
Super User
Super UserHן SCNCKS1
In order to connect the tables, you need to convert your rates table into a longitudinal table first.
Using unpivot in PQ :
After this your rates table will look as on pict :
From this stage ypu can just merge it based on item and quarter :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SCNCKS1Helper I
Helper IThank you!