cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
superME79
Frequent Visitor

DERIVATED TABLE

Hello everybody,
I would like to calculate a table by reviving it from another
example
table 1
a b c

table 2 bc

do you have any advice in DAX 🙂

1 ACCEPTED SOLUTION

@superME79 , Create a new Table like below:

Table 2 = SUMMARIZE(Table1,Table1[a],Table1[b])
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

View solution in original post

3 REPLIES 3
superME79
Frequent Visitor

table 1 

abc
asdwer123

 

table 2 

ab
asdwer

@superME79 , Create a new Table like below:

Table 2 = SUMMARIZE(Table1,Table1[a],Table1[b])
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis
Thejeswar
Super User
Super User

Hi,

A Better way to ask this question would be to share a sample for Table 1 and give an expected output for Table 2. That might fast track this question to being answered

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.