Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

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:

 

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

Best,
Jacek

 

8 Replies

  • It is not possible.

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

  •  

    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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

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

      • jaryszek's avatar
        jaryszek
        Icon for Super User rankSuper User

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