Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
m3awadhi
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
v-lili6-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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.

Hi  @v-lili6-msft

It is working now 
Thanks alot,
 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors