Forum Discussion

Helper I

8 years ago

Solved

Combination chart showing average rather than actual data values with combined dates

I've got 2 different excel sheets of data within the same time period, but one table is simply by year while the other has specific days within these years. Different date formats basically. I am...

Ashish_Mathur
8 years ago
Hi,

Share the link from where i can download your workbook.
Ashish_Mathur
8 years ago
Hi,

You may download my solution from here.

Hope this helps.

Helper I

8 years ago

Here you go:

https://drive.google.com/open?id=1CkyMMc6JpbV3OT8m3U6nX5iw8ydM5_Mw

Super User

8 years ago

Hi,

You may download my solution from here.

Hope this helps.

DataGeo
Helper I
8 years ago
Hi Ashish,

Really appreciate your help with this. I am trying to recreate your solution with my original workbook so I can learn the techniques here. I have been able to follow most of the DAX coding but am stuck now on one step. It seems you created a new "Date" column on the donation table to match the date format of the calendar table.

However when I use the code in your PowerBI file it is giving me an error, see image:

Any idea what I'm doing wrong here? So close!!
- Ashish_Mathur
  Super User
  8 years ago
  Hi,
  
  You are welcome. Ensure that the year column is a numeric column. If it still does not help, then share the download link of the file with your formulas. I will try to identify and correct for the error.
  - DataGeo
    Helper I
    8 years ago
    Hi Ashish,
    
    I tried changing the column to a date column exactly like how it is in your solution but could not get rid of this error. I don't understand why in your solution it works but in mine it is always giving an error.
    
    You will see it in the data table titled "Donations".
    
    Thanks again for your help with this.
    
    Here is the file: https://drive.google.com/open?id=1y1MQ7qbbpy2ja0q2lXE9rg0wGxlpKE5O