locked
Show a Data Model table as an Excel table/worksheet RRS feed

  • Question

  • Hi,

    I have a data model with just two tables that have a one-to-many relationship. One of the tables is a lookup table and I have used DAX (the RELATED function) to add a custom column to my main table.

    As well as PowerPivot of the model (which I have done), I would like to display the data model's main table as an Excel table on a worksheet. How can I do this without using pivot table?

    Thanks in advance.

    Tuesday, October 3, 2017 10:47 AM

Answers

  • Do a Reversed-Linked-Table
    as explained on page 418 of the book
    "Microsoft Excel 2013: Building Data Models with PowerPivot"
    by Ferrari & Russo.

    Friday, October 6, 2017 1:14 AM

All replies

  • Do a Reversed-Linked-Table
    as explained on page 418 of the book
    "Microsoft Excel 2013: Building Data Models with PowerPivot"
    by Ferrari & Russo.

    Friday, October 6, 2017 1:14 AM
  • The Power Pivot model base on some source data, so when you can get the source data into PP model, then you can get it in an Excel sheet as well.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, October 6, 2017 5:32 AM