You’re offline. This is a read only version of the page.
2
Dear Community,
hope this post finds you well , as i'm not able to find the proper solution.
I do have a Query that provides me an overview similar to the attached file.
Aim is to find the upcoming valuation for a new period - based on different criteria.
Explanation:
IF there is a Quantity on hand i want to receive the price of the location with highest quantity
IF there is no Quantity it is to be checked if there is a last valuation instead - if so - this one to be taken
IF both are not available but there was a calculation done (means a condition is set), this is to be taken
IF all three are not on hand, i want to refer to old pricing.
I tried to get the result with conditional column but in the end i do have 6 line (or pending on the object 1 to x lines), but only want to get one single line
Does anybody has a hint , an idead or solution how i can fix that? I'm trying to use this in Excel Power Query
thanks in advance, any input is appreciated
BR CIM1234
#1
mmbr1606
7
Super User 2025 Season 1
#2
SD-13050734-0
4
#3
lbendlin
2
Super User 2025 Season 1
Share
Report
All responses (
Answers (
