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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jaryszek
Post Prodigy
Post Prodigy

Each time when I am creating calculated column i need to set up currency

Hi Guys,

every time I created calculated DAX column I have my PLN values there if this is a currency field. 
So every time i need to go here:

jaryszek_0-1743760076472.png

 

and set up dolar as my default value,
How to set up this only once?

Best,
Jacek

 

1 ACCEPTED SOLUTION
8 REPLIES 8
jaryszek
Post Prodigy
Post Prodigy

 

thank you @ZhangKun @lbendlin .

Imagine that I am creating report for usa, poland and japan. 

How can I make this calculate column specific for local currency? I do not want to force it for only chosen one. 

Best,
Jacek

Define "local" . What should happen when a Japanese colleague visits the Warsaw office and looks at the report?

He will open report and see measure with japanese currency, not polish one. 

ZhangKun
Super User
Super User

It is not possible.

Please note that setting the currency format does not automatically convert every value in the column to currency type.

thanks

lbendlin
Super User
Super User

unfortunately there's no way to do that yet. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.