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

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      6 years ago

      Hi RobbeVL ,

       

      As we know we cannot create dynamic calculated column like that. Could you please tell me what is your formula of your measure [SalesRate]? Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

       

      • RobbeVL's avatar
        RobbeVL
        Impactful Individual
        6 years ago

        Hi  , 

        I was afraid this wouldnt be possible that way.

        In the table I would need for example this measure:

        Rebitda = CALCULATE([Balance]; 'R-Account'[PL6]= "REBITDA")
              Balance = SUM('ZZ_PCABOOKING_CORE'[DEBIT])+SUM('ZZ_PCABOOKING_CORE'[CREDIT])
        Rebitda_LastMonth = Is a measure refering to the previous month.
         
         
        Expected result being: (could also just be a date, but aggregated on month level))

        Year Month BU REBITA REBITA_LM
        2019 01 VW 100  
        2019 02 VW 120 100
        2019 01 BV 100  
        2019 02 BV 120 100
        ...        
         
         
        thx,
         
        Robbe