Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi arjun0028,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to grazitti_sapna and cengizhanarslan  for prompt and helpful responses.

 

The issue usually happens when the time intelligence calculation is using the date column from the fact table instead of a proper calendar table, especially when the visual is grouped by a sorted month field. Functions like DATEADD work correctly only with a continuous date column from a dedicated Date/Calendar table. I would recommend creating or using a Calendar table, marking it as a Date table, and creating an active relationship between Calendar[Date] and 'Booking Live Data'[BC_Date]. Then update the MoM calculation to use Calendar[Date] inside DATEADD and use the month name from the Calendar table in the matrix. This usually resolves issues where the MoM growth shows 0 or constant values.

 

Thanks & Regards,

Prasanna Kumar

arjun0028's avatar
arjun0028
Regular Visitor
6 months ago

Is there any other alternative method because the calendar method has not worked out properly despite trying it out

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    6 months ago

    Hi arjun0028,

     

    I've already shared an .pbix file working example, you can add those columns to your existing table and try using it