Forum Discussion

keen's avatar
keen
Frequent Visitor
2 years ago

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...
Need Help
keen's avatar
keen
Frequent Visitor
2 years ago

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's avatar
PijushRoy
Community Champion
2 years ago

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)