tabular data model

  1. M

    Make IRR function using DAX

    Hi All, I need to calculate the IRR value using DAX into tabular data model similar like XIRR. After the analysis that the while loop function not supported using DAX so I amunable to calculate the IRR value. can anyone help me to calculate IRR value using DAX into tabular data model? or If...
  2. E

    100% ALLSELECTED or Other Filter

    We have a need to analyze sales by sales type , region and period (Month/Quarter/Year). When choosing the values from the above filters the 100% reference should be by the chosen filters and not by the whole derived data. For example, If I choose to filter and present Sales order of type...
  3. R

    Excel 2013 Renaming column headings automatically

    I am using Power Pivot to pull in data from a SSAS tabular model and then creating an excel worksheet with data from the Power Pivot model. Unfortunately, the headings always include tablenamecolumnnamecolumnname (i.e. CustomerCustomerPhoneNumberCustomerPhoneNumber and PhoneNumber). If I have...
  4. L

    Show a Column from Fact A table inside a Fact table B

    My primary question is: How should I enable to make column "name" from table fact_B to be displayed inside of table Fact_A by with support of DAX code only? Additional info: - In this context, I cant use SQL code - The relationship is one to may between fact and dim table in the tabular...
  5. E

    How should data model be set up?

    I have three files: - Sites - NAICS - Interests All are tied together by the SiteID. Sites functions as the lookup table based on the SiteID as there are no duplicate records. Both NAICS and Interests have multiple records for a SiteID. I need to create a report with information from both...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top