Forum Discussion

Mpmp1's avatar
Mpmp1
New Member
8 days ago

Dynamic headers for a balance sheet

My company is using a fabric model and I am currently creating a balance sheet report.  This report will allow users to select the currency they are interested in (e.g system currency which would be...
General Comment
Need Help
Murtaza_Ghafoor's avatar
Murtaza_Ghafoor
Icon for Super User rankSuper User
8 days ago

Mpmp1​ 

Yes this possible,  assume your legal-entity dimension has:

  • Country             Local Currency
  • UAE                   AED
  • Belgium            EUR
  • China                CNY
  • UK                    GBP

Create a currency display column:

Country Currency Display =

'DimLegalEntity'[Country] & " (" & 'DimLegalEntity'[LocalCurrency] & ")"

If this helps, ✓ Mark as Kudos | Help Other