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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
jaryszek
Memorable Member
Memorable Member

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
Memorable Member
Memorable Member

 

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.