You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected currency. You need to…

Question

Options

• Aa field parameter
• Ba linguistic schema
• Ca dynamic format string
• Dthe WINDOW DAX function

• A
  3% (2)
• B
  8% (5)
• C
  73% (47)
• D
  16% (10)

Explanation

Power BI, Create dynamic format strings for measures With dynamic format strings for measures, you can determine how measures appear in visuals by conditionally applying a format string with a separate DAX expression. A common scenario with financial reports is showing the currency converted to other country currencies by multiplying the base currency by an exchange rate. This also takes advantage of the dynamic format strings of calculation items to show the converted currency also in the correct currency format. Calculation items can have the conversion DAX expression defined once that can be applied to the many measures in the model showing currency values, without the need to edit or duplicate many measures. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation- group-authoring-and-creating-relationships-in-the-properties-pane/

No community discussion yet for this question.