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 clarifying the problem for me. Please explain with an example.

You can share sample and sample output data.

Appreciate your congratulations.

RobbeVL's avatar
RobbeVL
Impactful Individual
6 years ago

I seem to get the correct result using the following:

SUMMARIZE(
              GENERATE ( 'Date'; 'Business Unit' );
               'Date'[Year];
               'Business Unit'[DIM_BUSINESSUNIT_ID];
                "Sales"; [SalesRate];
                "SalesLY; ???)

 

But how do I show the Sales of last year in this summarize?

 

Robbe