The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I'm currently trying to create a sales per region dashboard and would like to ask for some advice on my query. I currently have my sales for a selected year as:
Thanks!
Hi @RichardC12 ,
Regarding the issue we discussed earlier, I wonder if this has been resolved now? It's been a long time since I've heard back from you and I'm not sure if all is well. Please feel free to let me know if there is anything else I can do to help.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RichardC12 ,
For your problem, here is the solution I have given which should optimize your DAX query taking too long.
Measure = VAR current1 =MAX('financials'[Date])
VAR late =DATE(YEAR(current1)-1 ,MONTH(current1),DAY(current1)
)
RETURN CALCULATE(SUM(financials[ Sales]),financials[Date]<=late, YEAR('financials'[Date])=YEAR(late))
I kept your first two self-defined parameters and then calculated your latter part directly using caculate,
in my example data, the speed is getting faster, I hope this helps.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
24 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
9 | |
9 |