Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How create relationship between budget sheet and Sales table

Hi All,   I have problem creating relationship between budget and sales table   1. I have budget in Excel workbook, Consists of Monthly and weekly budget 2. Need to compare monthly and weekly b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Phil_Seamark,

 

 

Calender Month coloumn is set as Whole Number .

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI Anonymous

 

Can you add a date column to that table?

 

How big is your data file?  If you share it to me privately I can tidy it up if you like

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Phil_Seamark,

     

    You want to me add Date coloumn to Budget Table???. Date table already have Date coloumn. How can I Share file with you?

     

    Thanks.

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI Anonymous

     

    Upload your PBIX file to a OneDrive, or Dropbox and send me a direct message with a link to it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Phil_Seamark,

     

     

    I have added one more column to my budget table(Month start date ) and tried connecting to Date Table - Sales Table.

    But still, I am not able to filter budget by Warehouse and category. 

     

    Thanks

    Mazhar