Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |