cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
m3awadhi Frequent Visitor
Frequent Visitor

Aggregation not working when using Date Table

Hello everybody,
I have two tables in my model ,first  table is Calculated  Dates Table .
Second table is Requests Table as shown below,
Both Tables have Year Field, 
Everything is working as expected when I do aggregation based on year field from Requests Table.
Requests.png
But aggregation is not working when i use Year Field from Dates table,
I have attached pbix  and  excel file,
RequestsDev.pbix
Requests.xlsx
Kindly check 
Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Aggregation not working when using Date Table

Hi@ m3awadhi 

After my research , you need to and a new column and create the relationship between Requests and Dates by 

the new column and date instead of CreatedOn and date like below:

Column = DATEVALUE(Requests[CreatedOn])

4.PNG

Result:

5.png

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Aggregation not working when using Date Table

Hi@ m3awadhi 

After my research , you need to and a new column and create the relationship between Requests and Dates by 

the new column and date instead of CreatedOn and date like below:

Column = DATEVALUE(Requests[CreatedOn])

4.PNG

Result:

5.png

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
m3awadhi Frequent Visitor
Frequent Visitor

Re: Aggregation not working when using Date Table

Hi  @v-lili6-msft

It is working now 
Thanks alot,