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
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
