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 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 ?

 

Need Help

4 Replies

  • 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?