Forum Discussion

RobbeVL's avatar
RobbeVL
Impactful Individual
6 years ago

Creating a Calculated table with multiple levels

Hi all,   A little help with creating this table would be nice. I have quite a complex dataset, but I would like to complete this "simple" DAX measure.  I want a Calculated Table with the fol...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output.

Appreciate your Kudos.

  • RobbeVL's avatar
    RobbeVL
    Impactful Individual
    6 years ago

    Hi amitchandak ,

    I dont really know how to explain anymore. This is the way someone forwarded it to me. Seemed clear to me.
    The result should be something like this:

    BU is a Dimension, Year is from a dimension, but Sales is a measure based on 5+ tables with references to multiple other measures)
    If I would drag and drop this in a matrix table, i'd get the result quite easy.

    But how to "hardcode" this in a Calculated table? 


     

    BU Year Sales SalesLY
    Unit 1 2019 1000  
    Unit 1 2020 2000 1000
    Unit 2 2019 1500  
    Unit 2 2020 2000 1500

     

    Regards,

     

    Robbe