Forum Discussion

ANE2's avatar
ANE2
Frequent Visitor
2 years ago

Time intelligence Past year sales

Hi, I am trying to calculate last year sales using a 454 fiscal calendar. The normal time intelligence functions like dateadd, same period last year don't seem to work. The fiscal week on my calendar...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ANE2 ,

 

Sorry, I don't quite understand your problem, could you use a pbix file, screenshot or other way to describe your problem in more detail and visually so that I can better help you.

 

Best Regards,

Clara Gong

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

ANE2's avatar
ANE2
Frequent Visitor
2 years ago

Anonymous what I mean is when I select a filter from the slicer the values are static and also I am having a straight line on the line chart for the previous year value which is not what I want. I want the previous year values on the line chat to be dynamic just like this year values 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ANE2 ,

     

    Can I ask you if your LY Net Demand is obtained by calculating the columns? If yes, please change it to be calculated using MEASUREMENT. Calculated columns are static values that are added to a table and are calculated row by row as the data is loaded. In contrast, a measure is a dynamic value that changes based on what you are viewing in the report, calculated dynamically in the context of the visual object's filters. More detailed information can be found at the link: Understanding Measures vs Calculated Columns in Power BI (gorilla.bi)

     

    Best Regards,

    Clara Gong

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

    • ANE2's avatar
      ANE2
      Frequent Visitor
      2 years ago

      Anonymous @Hi, no LY Net Demand is calculated using a measure not a calculated column 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi ANE2 ,

         

        If you are basing your LY Net Demand on my previous reply, then it gets the sum of the same week as last year, so it doesn't change based on each day in the line graph.


        Also, if you want it to vary with the number of days, then consider the dates relative to last year, not the number of weeks, because as mentioned before, the same number of weeks does not correspond to the same number of days, which contradicts the display you are looking for.

         

        Best Regards,

        Clara Gong

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