Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
keen
Frequent Visitor

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?

keen_3-1703865076030.png

Current Product A outcome: booking prev month ok

keen_0-1703864953848.png

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

keen_1-1703864979184.png

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

keen_2-1703865001579.png

 

4 REPLIES 4
PijushRoy
Super User
Super User

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

PijushRoy_0-1703878479623.png

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

 

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

keen_0-1703913170844.png

Product B

keen_1-1703913188759.pngkeen_2-1703913209645.png

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)

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?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors