The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@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)))
@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:
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
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |