Results 1 to 2 of 2

Thread: Need DAX formula for PowerPivot

  1. #1

    Need DAX formula for PowerPivot



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I am new to this forum.
    Need a small help regarding building DAX formula for PowerPivot.
    I have two tables in one sheet in excel. One is City and State data with Promotion Start Date and End Date.
    The second one is just a list of days with date, month name and year for 2009 and 2010.

    I want to match first table with second to create a Power Pivot which should be as follows:

    1. Row Heading should contain State from first table
    2. Column Heading should contain Year and month from second table.
    3. Values should be populated with count of state against each month.

    I have prepared a sample output table manually. Please refer to screenshots below for both input tables and desired output sheet.

    Click image for larger version. 

Name:	First Table.png 
Views:	44 
Size:	57.9 KB 
ID:	994 Click image for larger version. 

Name:	Second Table.png 
Views:	33 
Size:	32.6 KB 
ID:	995

    I know and can achieve row heading and column heading sections easily but unable to build a DAX measure to populate value section.
    Request you to please help build this formula. Looking for a quick response and would appreciate your effort on this.

    Note: Also attaching the excel file for your reference that am working on.

    Thanks in advance
    Md Sarfaraz
    Attached Files Attached Files

  2. #2
    Excel 2010 with free PowerPivot Add-In
    http://58918aa17d4002474361-7ac2b7ee...05_07_13a.xlsx
    If you get *.zip, don't unzip, just rename *.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •