Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
nalmeida
Regular Visitor

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

 

CIGqP1o

 


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

3 REPLIES 3
amitchandak
Super User
Super User

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

 

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

 


@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
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.