Forum Discussion

nalmeida's avatar
nalmeida
Regular Visitor
4 years ago

% Growth

Hi all, Im fairly new to Power BI and I need to know the % growth of my company.

Yesterday I came across one of BI's Elite videos (DAX for Power BI - Dynamic % Change - YouTube) where he shows you how to calculate % Change over various dates.


I followed the instructions correctly, measures are fain and all. But how can the third quarter of 2020 (2020 Trim 3) shows only a 1.47 % change when it when from 159.8mill (2020 Trim 2) to 394.7mill in the next quarter...

 

 


To give you some context, i'm trying to show % growth or decrease

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    nalmeida , do you have date table? and have you used measures like these

     

    QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
    Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

     

     

     

    • nalmeida's avatar
      nalmeida
      Regular Visitor
      4 years ago

       

      amitchandak wrote:

      nalmeida, do you have date table? and have you used measures like these

       

      QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
      Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

       

      Hi!

      Yes, I have a date table where it shows day, month, Q, and year. 

      No, I used the same exact measures shown in the video: 

       

      % Change =
      VAR CurrentValue = [Total en medida]
      VAR PreviousValue =
      SWITCH(
      TRUE(),
      ISINSCOPE(Consolidado[Fecha de pedido].[Día]), CALCULATE([Total en medida], DATEADD(Consolidado[Fecha de pedido].[Date], -1, DAY)),
      ISINSCOPE(Consolidado[Fecha de pedido].[Mes]), CALCULATE([Total en medida], PARALLELPERIOD(Consolidado[Fecha de pedido].[Date], -1, MONTH)),
      ISINSCOPE(Consolidado[Fecha de pedido].[Trimestre]), CALCULATE([Total en medida], PARALLELPERIOD(Consolidado[Fecha de pedido].[Date], -1, QUARTER)),
      ISINSCOPE(Consolidado[Fecha de pedido].[Año]), CALCULATE([Total en medida], PARALLELPERIOD(Consolidado[Fecha de pedido].[Date], -1, YEAR))
      )
      Return
      DIVIDE(
      CurrentValue - PreviousValue,
      PreviousValue
      )

      At this point Im pretty confused, maybe this it not the right measure to show % in growth. 

      Im going to try with the measure that you mention of course.
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi nalmeida,

        Did you apply any other filters on your table records that may affect the date table records? AFAIK, time intelligence functions require a complete calendar table for calculating. Perhaps you can try to use date function manly filter specific date range to calculate.

        Time Intelligence "The Hard Way" (TITHW)  
        Regards,

        Xiaoxin Sheng