Forum Discussion
Still getting error with IFERROR()
CALCULATE(
//[K_YTDDatePrevYear]: this measure is flag that marks all the dates till today of previous yr as TRUE().
But I'm getting the error when I select the yr 2024 from the filter:
And even after using the functions IFERROR() and ISERROR() I'm still getting the same error.
Can anyone let me know what I'm doing wrong here.
Thankyou for your time!!
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.
1 Reply
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.