How to compare all-time monthly values and output percentage changes ?
Hello Community, I am experiencing difficulty creating a DAX Command that compares my monthly averages and percentage changes. I need to see all-time average rather than the average for the month. I will include the information below. I need to display the % change in a table with the following columns: Product Identification, (All time - 2022-9), (All time - 2022-10), and % change. I do not own the live dataset. Any help would be greatly appreciated. I will provide images below. Thank you! Best,
Calculate monthly distribution between two tables
Hi, I've been trying to create a report which estimates the monthly distribution based on two tables. Table 1 contains Year-Month, country and weight based on shipping data. Year-Month Country Weight Kg 2021-01 Norway 15 2021-01 Canada 2 2021-02 Norway 10 2021-02 Brazil 3 Table 2 contains Year-Month, weight, and attributes based on transactions. Year-Month Weight Kg Attribute 1 Attribute 2 Attribute 3 2021-01 12 A A B 2021-01 5 B C A 2021-02 3 C B A 2021-02 9 B B B I'm trying to estimate the distribution of each attribute with each country based weight distribution per month. My plan is to calculate the total attribute weight per month, get a ratio and then distribute it to each country. The total weight per month doesn't need to add upp to the toal attribute weight per month, only the ratios are important. In this example I want the following: 2021-01: Total attribute weight 17 Kg, 12/17 has [A,A,B] and 5/17 has [B,C,A] 2021-02: Total attribute weight 12 Kg, 3/12 has [C,B,A] and 9/12 has [B,B,B] The end table should then show Year-month Country Attribute Weight Kg Attribute 1 Attribute 2 Attribute 3 2021-01 Norway 12*(12/17) A A B 2021-01 Norway 12*(5/17) B C A 2021-01 Canada 5*(12/17) A A B 2021-01 Canada 5*(5/17) B C A 2021-02 Norway 10*(3/12) C B A 2021-02 Norway 10*(9/12) B B B 2021-02 Brazil 3*(3/12) C B A 2021-02 Brazil 3*(9/12) B B B Any help regarding this would be greatly apprechiated!
Percentage calculation by month
Hi all, I am calculating office attendance and created the following table showing attendance for all period on my dates table and the calculation is correct as per below: I want to keep the same result if no period is selected but i want the result to change if a select a specific period but im getting the following whenever i select a period from the slicer: I am basically trying to get a 100% as a total for that month and my daily percenatge to be calculated accordingly and the result should be like: Total = 100% Monday = (32/142) = 22% Tuesday = ( 26/142) = 18% My weekday % split calc is = weekday % split for office w = DIVIDE(CALCULATE(COUNTA('data sample'[Day Name]), 'data sample'[Location] = "Office"), CALCULATE([Office attendance] , ALL('Dates table'))) Any guidance or help would be appreciated. Thank you.
