Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

YOY Quick Measure

Hi I have used the followimg quick YOY measure. All works well. However, for my current year I dont have data for all the months yet. My report now shows a 100% YoY negative growth. How do I fix this...
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi. I usually don't recommend quick measures because you don't write the idea you want. Anyway, I think this might be because AutoDateTime time intelligense option in power bi will create a table which the last date is 31/12/ActualYear. I'm talking about this: 'BI_Category'[Period_From_Date].[Date]

    If you create your own Calendar Date Table you can control it to have data untill today. Relate it to your table and use the Date Column of the calendar table in that formula. You can check how to create a table like this in here.

     

    Regards,

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

ibarrau's avatar
ibarrau
Super User
6 years ago

Hi. I usually don't recommend quick measures because you don't write the idea you want. Anyway, I think this might be because AutoDateTime time intelligense option in power bi will create a table which the last date is 31/12/ActualYear. I'm talking about this: 'BI_Category'[Period_From_Date].[Date]

If you create your own Calendar Date Table you can control it to have data untill today. Relate it to your table and use the Date Column of the calendar table in that formula. You can check how to create a table like this in here.

 

Regards,

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