Forum Discussion

SuperSayan's avatar
SuperSayan
Resolver I
8 years ago
Solved

Sum data by dates from 2 different tables

Hi Everyone,   I'm trying to sum data from 2 different tables. Here is a simplification of the data: Table 1: - Column 1: date of sale - Column 2 : price of sale A lot of other columns   Tabl...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    SuperSayan,

     

    Create a calendar table and build relationship on date column with your existing tables.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

SuperSayan,

 

Create a calendar table and build relationship on date column with your existing tables.

SuperSayan's avatar
SuperSayan
Resolver I
8 years ago

Hello v-chuncz-msft,

 

I was a bit reluctant to go down that road but at this point it looked like a good way out.

So I did that and I got a very surprising behaviour.

 

I am using one date from a table in different measure with the year info (example below), sorry my Power BI is in French...

But the error message is not very complicated, it is telling me that the date in my table (that I linked to the calendar table) has no "Year" attribute... I confirm my data is Date type (dd/mm/yyyy format).

 

réalisé 2017 = COUNTROWS(FILTER(HistoriqueInter;HistoriqueInter[FinréelleDateH].[Year]=2017))

 

 

PS: As soon as I remove the relationship on the date between my content table and the calendar table, the measure is working again...