Forum Discussion

raddy_dee's avatar
raddy_dee
New Member
1 year ago
Solved

Create New Table with Existing Measure

Hello all.   I have created some measures in my project which I can successfully display in Table-Visual. However, how can I replicate this visualised table in a new Table? Basically what the mea...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi raddy_dee - You can use DAX to create a new calculated table that mirrors the aggregation of your existing table visual. Here's how to approach it:

    1. Go to "Modeling" Tab in Power BI Desktop.

    2. Click on New Table to create a calculated table.

    NewTable =
    SUMMARIZE(
    ExistingTable,
    ExistingTable[Department],
    ExistingTable[Month],
    ExistingTable[Year],
    "Points", [Points_Measure]
    )

     

    These methods should help you replicate the logic and layout of your existing table visual in a new table format. Hope this helps

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi raddy_dee - You can use DAX to create a new calculated table that mirrors the aggregation of your existing table visual. Here's how to approach it:

  1. Go to "Modeling" Tab in Power BI Desktop.

  2. Click on New Table to create a calculated table.

NewTable =
SUMMARIZE(
ExistingTable,
ExistingTable[Department],
ExistingTable[Month],
ExistingTable[Year],
"Points", [Points_Measure]
)

 

These methods should help you replicate the logic and layout of your existing table visual in a new table format. Hope this helps