New column formula won't save

[drgoatboy]

Hi everyone, 

I'm new to powerbi but enjoying finding my way!

I have a weird problem and I don't know why this is happening.

I wanted to create separate columns for quarterly costs.

I created a new column called 1q.

1q = if('all costs'[fiscal quarter]="1", 'all cost'[cost],0)

This works great! 

But when I try to create a second column for 2q

2q = if('all costs'[fiscal quarter]="2", 'all cost'[cost],0)

When I hit enter powerbi says it's working on it and then the column just changes to

column =

And the formula won't save. No error message, nothing.

I've tried calling it something else in case 2q clashes somewhere and that doesn't help. 

I've deleted calculated columns in case there are too many but that's not made any difference.

I can add other columns. For example it happily lets me add 2q = 2

I'm rather confused 🤔 

Can anyone help please?

Thanks. DRG

[v-saisrao-msft]

Hi @drgoatboy ,
Can you confirm if your issue is resolved? If it still persists, please consider reaching out to Microsoft Support. Provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your issue or provide a solution that isn't immediately obvious.

You can create a Microsoft support ticket with the help of the link below:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[Stephen_Hilton]

Hey - I think this is a new bug, I've seen it today also, alongside sometimes when the refresh dialog box is completely black.

[ahmedoye]

That's a weird one. Try to write the same formula differently without including the Table name. Like: 
2q = if([fiscal quarter]="2", [cost],0)

[SEMattis]

Try moving the creation of the columns to the QueryEditor and a CustomColumn for both Q1 and Q2 calculations. It would look something like:

Table.AddColumn( #PreviousStepinQueryEditor, "Q1", each if [fiscal quarter] = "1" then [cost] else 0). To add the column you can either click the Add Custom Column button in the Query Editor or add code in the advanced editor:

To give you an idea of how it has been implemented on my side: