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 y...
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