topic Re: % Growth in DAX Commands and Tips

% Growth

nalmeida — Thu, 18 Nov 2021 14:10:42 GMT

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

Re: % Growth

amitchandak — Thu, 18 Nov 2021 17:49:55 GMT

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)))

Re: % Growth

nalmeida — Thu, 18 Nov 2021 18:15:22 GMT

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.

Re: % Growth

Anonymous — Thu, 25 Nov 2021 06:22:59 GMT

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