Dateadd function error for some product

[keen]

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 Product A outcome: booking prev month ok

Current Product B outcome: why the booking prev month data disapperad ?

Current Product C outcome:why the booking prev month data disapperad ?

[PijushRoy]

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

[keen]

I try use dateadd , parallelperiod, previousmonth function to create previous month booking. 

Some of the product ok to appear previousmonthbooking, but some products are not .

Product is slicer.

Please see example at below. What is the wrong step i apply ? 

Product a

Product B

[PijushRoy]

Hi @keen 

Please create one sample pbix file and share google drive link (give access to anyone) to get answer quickly. (Only sample data, remove sensitive information)

[keen]

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?