Forum Discussion
Static Data alongside Live Data
Your baseline table is frozen, so it will never create new rows, in order to see new items from Live (like 4 and 5), let the Live table drive the rows and just pull in Baseline values where they exist:
In Power Query, merge Live with Baseline on the GUID using a Left Outer join and expand the Baseline column.
Or in DAX, add a column in Live with:
Baseline_Value =
LOOKUPVALUE(Baseline[Baseline_Value], Baseline[GUID], Live[GUID])That way all Live rows show up, with blanks for Baseline when there’s no match.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Your baseline table is frozen, so it will never create new rows, in order to see new items from Live (like 4 and 5), let the Live table drive the rows and just pull in Baseline values where they exist:
In Power Query, merge Live with Baseline on the GUID using a Left Outer join and expand the Baseline column.
Or in DAX, add a column in Live with:
Baseline_Value =
LOOKUPVALUE(Baseline[Baseline_Value], Baseline[GUID], Live[GUID])
That way all Live rows show up, with blanks for Baseline when there’s no match.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Perfect, thank you so much.
I now get this error message upon publishing - I am unable to view these workings Online?
