Is there a way to bring data from a metric to a dimension property?

  • 7 February 2023
  • 1 reply

Userlevel 2
Badge +1

I have a metric containing data that I would like to associate to a dimension list property, the LASTNONBLANK formulae is not working.


Best answer by francois 7 February 2023, 16:40

View original

1 reply

Userlevel 6
Badge +7

Hi Khadija,

Typically, any formula that produces a one-dimension structure can be used in making a property in a dimension. You can use the Formula Playground in Automatic Structure and work towards a result that has a structure of one dimension. You’ll then be able to use that formula in a property of the same format.

For dimension-format items, we typically use the LASTNONBLANK aggregator to get rid of additional dimensions.

For example, if I have a metric that describes in which country my employees are in any given month (Country metric by Employee x Month), I can use the following formula to create a Last Country in my employee dimension: 'Country by Employee and Month'[REMOVE LASTNONBLANK: Month]

The formula needed and its result will entirely depend on your model though.

Is there an error message that you get I can help you with? If you share the structure of your source metric, I can probably help you get to a working formula.