Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, Friends.
I've breaked my brains with a solution, still can't do a simple calcucation (on first sight).
I have by week chart with volumes (packs), data set has max week 15 and min week 7.
Also I have another visual - table with products: [Product name], [Current Week vol], [Previous week vol].
Now comes the hardest.
What I'm trying to achieve with interactions is - if no bar is selected, then in table week volume for current should be max week available and for previous week its previous one. But when i select a bar (in ex. week 7), then current week should have volume of the 7th and previous week - 6th.
I've gone so far to a measure for previous week as :
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.
My mistake. Here is sample of my data:
area | Sales point | Channel | Product family | Product name | week_number | month_number | year_number | Volume packs |
Centre | CEN122 | Retail | Family 1 | Product 1 | 13 | 3 | 2020 | 440 |
North | NOR183 | Wholesale | Family 1 | Product 1 | 9 | 2 | 2020 | 1650 |
North | NOR088 | Retail | Family 1 | Product 1 | 12 | 3 | 2020 | 550 |
East | EAS148 | Retail | Family 1 | Product 1 | 10 | 3 | 2020 | 10450 |
East | EAS251 | Key Account | Family 1 | Product 1 | 10 | 3 | 2020 | 1952.5 |
East | EAS192 | Retail | Family 1 | Product 1 | 10 | 3 | 2020 | 9536.45 |
South | SOU022 | Key Account | Family 1 | Product 1 | 10 | 3 | 2020 | 3047 |
Centre | CEN069 | Retail | Family 1 | Product 1 | 10 | 3 | 2020 | 1002.1 |
Table in report looks like:
Product ID | Week Selected | Previous Week |
Product 1 | ||
Product 2 | ||
Product n |
Thanks in advance.
Having a difficult time following this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |