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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hmonty
Frequent Visitor

Unable to create a new calculated column / measure unless I overwrite an existing one

Hello

I have a power bi report that already has data loaded and many calculated columns and a separate measure table.

I have copied this report and made adjustments to some of the tables in powerquery (i.e., filtering the data to show plan number 5 instead of #4), nothing too crazy. The Plan has associated actions that hold various dates (start, target, completion etc) and I have split these out into their own tables.

I've use parameters to enable the switching between plan # and action references.

 

The data loads no problem, and I can 'see' the data is as expected.

When I go to an existing calculated column, I can revise the action references and the output works no problem.

However, If I take the same DAX (that has just worked) and try to create a new calculated column (with a different name), it errors and tells me the table can’t be found or is not available for use.

 

I will probbaly end up building a new report from scratch, but it would be useful to copy and tweak the one I have already.

 

Has anyone else has experience this odd phenomenon recently, and if so have you found a solution?

Awaiting responses with interest!

H

 

1 REPLY 1
lbendlin
Super User
Super User

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.