Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone,
I am facing issue which I will explain here.
Below is the screenshot which shows percentage values.
Delta difference is difference beteen change in Price% - Change in Cost %
If I want to take weekly wise sum of Delta difference then this is not showing up actually.
As shown in above screenshot, January 18 should be sum of all delta difference values for Jan 18 but it is giving us 4.8% which it should not be.
Could someone please help me on this?
Solved! Go to Solution.
@apatwal
I recommend cheking out this post by SQLBI: https://www.sqlbi.com/articles/working-below-a-dax-formulas-granularity/
explaining how to deal with these kinds of granularity changes. If this still doesn't help you to solve the issue. I request that you add sample data in table format and ping me with @.
Proud to be a Super User!
Hi,
What is the dax you use for Delta difference? I think by using SUMX you can get the value you want.
Proud to be a Super User!
Hi,
The DAX used in as below:
Okay,
The issue here is that your % measures are beign calculated in the context of "week start date". This means that e.g. change in price % calculates the sum of values where [week start date] = 1.18.2021 for example. These sums are then used to calculate a single value for change %. To counter this I recommend using SUMX in your Delta difference: https://docs.microsoft.com/en-us/dax/sumx-function-dax
Proud to be a Super User!
Hi,
Thanks for your reply!
I performed as it was suggested but it doesn't help me to acheive.
DAX used for delta difference:
@apatwal
I recommend cheking out this post by SQLBI: https://www.sqlbi.com/articles/working-below-a-dax-formulas-granularity/
explaining how to deal with these kinds of granularity changes. If this still doesn't help you to solve the issue. I request that you add sample data in table format and ping me with @.
Proud to be a Super User!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |