Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Creating a new calculated column makes an existing calculated column blank

I have a table which contains event name, event edition code(year), revenue and then a calculated column called Prior Year which derives the prior year based on the last year with non blank revenue. As seen below, it works fine, the calculated column is returning the values I want



The issue is when I create a new calculated column called key. For some reason, when I create that calculated column, the Prior Year calculated column from before turns up blank as seen below. I've played around with it creating a new column with just key = 'Prior Editions'[eventeditioncode] is enough to make the Prior Year column become blank

key = 
    'Prior Editions'[eventname],
    'Prior Editions'[eventeditioncode]



What in the world is going on? I've never ever encountered this kind of issue before!

Resident Rockstar
Resident Rockstar

Hi @RingoMoon - Hope you have first created the prior year column then key column.You can check the dependency view in Power BI to see how columns are dependent on each other.


Slight modification in Prior Key calculation:

Prior Year =
VAR CurrentYear = 'Events'[EventEditionCode]
VAR EventName = 'Events'[EventName]
'Events'[EventName] = EventName &&
'Events'[EventEditionCode] < CurrentYear &&


Now define your key column :

key =


try the above calculation and make sure the key column and prior key columns are not dependant each other (circular dependency). Hope it works . please try


Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.