I have a Date table and when I try to calculate previous day views I get Blank. It doesn't matter whether I try using the function PREVIOUSDAY or DATEADD. Now if I remove the Date table and use the d...
Hi nleuck_101
Sorry for the late reply.
This does have the potential to cause the issue.
Maybe you can try to create a new calendar table including the latest date and try again, the outcome of the PREVIOUSDAY() function could only being included in the table.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.