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

View all the Fabric Data Days sessions on demand. View schedule

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.