Forum Discussion
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...
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.
Hi v-frfei-msft ,
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