Forum Discussion

Michael_S_1984's avatar
Michael_S_1984
New Member
9 months ago
Solved

Static Data alongside Live Data

Hello I have an imported dataset/table from another pbix that I have chosen to no longer refresh - the hope is that it allows me to have a 'Baseline' dataset at a point in time, to then compare with...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    9 months ago

    Hi Michael_S_1984 

     

    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 💡

     

    🟩 Follow me on LinkedIn

DataVitalizer's avatar
DataVitalizer
Super User
9 months ago

Hi Michael_S_1984 

 

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 💡

 

🟩 Follow me on LinkedIn

Michael_S_1984's avatar
Michael_S_1984
New Member
9 months ago

Perfect, thank you so much.