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.
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
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])
Result:
Best Regards,
Lin
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])
Result:
Best Regards,
Lin
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
