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

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'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)

  • keen's avatar
    keen
    Frequent Visitor
    2 years ago

    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?