Forum Discussion
Dateadd function error for some product
Hi Team, I use this formula to get previous month total booking. Relationship- (Booking table (*) & Date table (1)) but why some of the product bookingprevmonth data disappeared? Current P...
Hi keen
Please check the date for Products B, C, and Calendar Date
The calendar date is marked as a Date Table in Power BI
Check the Measure, [Total Booking Qty] is not exclude the Product B and Product C
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
Yes, The calendar date is marked as a Date Table in Power BI
Total Booking QTY = sum(Booking[Qty])
Everything check ok.
but reach dateadd function, some products no able to get Bookingprevmonth , why this happen?