Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with time intelligence and Quick Measure

Hey guys, 

 

Super new to Power Bi, just started using today.

 

So, I do want to create a MoM for my dataset. my current table (File_ID) had  a column called deploment date date had which set the PowerBi Hierachy. After reading many feedback here, I went a head and created a calendar table then join it with the file id. Once join, I use this fomula

VAR __PREV_MONTH =
        CALCULATE(
            SUM('File for ID'[EM_Delivered]),
            DATEADD('Calendar'[Date].[Date], -1, MONTH)
        )
    RETURN
        DIVIDE(SUM('File for ID'[EM_Delivered]) - __PREV_MONTH, __PREV_MONTH)
and the error that used to have disappeared.
This is my current table: is it normal for the Total MoM to be 0%. In some example that I saw, the total always had something. Thanks for your feedback
 
 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    In my opinion, it is not normal for the Total MoM to be 0%. I did some test of using your formula and the result looks normal：

    I think there might be something wrong in other place. Could you please share your pbix to me if you don't have any Confidential Information?
    BTW, here's my pbix for your reference. Hopefully works for you.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    In my opinion, it is not normal for the Total MoM to be 0%. I did some test of using your formula and the result looks normal：

    I think there might be something wrong in other place. Could you please share your pbix to me if you don't have any Confidential Information?
    BTW, here's my pbix for your reference. Hopefully works for you.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly