Still getting error with IFERROR()

Hi Anonymous 

Please check the following

1.Whether your date table is in a one-to-many relationship with the data table, and if it is a many-to-many relationship, the error shown in the figure may occur

2.Whether your date table and data table are one-way joins.

You can refer to the following link.

Solved: Contiguous date selection error - YTD LY - Microsoft Fabric Community

Solved: Function 'SAMEPERIODLASTYEAR' expects a contiguous... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.