DAX- Pre and Post Category averages on specific date
Hi everyone, I am struggling with DAX for this poblem, Data looks like this (4th column I added for reference) Date Category Value 1/1/2023 A 12 1/3/2023 D 22 1/6/2023 A 34 1/7/2023 D 19 Pre 2 1/8/2023 A 7 1/10/2023 S 22 1/12/2023 A 34 1/27/2023 S 12 Pre 2 2/14/2023 D 13 Pre 1 4/3/2023 A 24 Pre 2 4/5/2023 S 16 Pre 1 4/7/2023 A 13 Pre 1 4/18/2023 D 11 Post 1 5/1/2023 A 5 Post 1 5/2/2023 S 15 Post 1 5/2/2023 S 4 Post 2 5/3/2023 D 7 Post 2 5/4/2023 A 5 Post 2 5/23/2023 D 15 5/30/2023 S 21 On any specific day which is in another table for example 4/8/23 for A, D and S. They could also say just 5/10/23 for A and D I need Pre and Post averages of 2 values, then calculate the difference Category A D S Previous 2 18.5 16 14 Post 2 5 14 9.5 Difference 13.5 2 4.5 any help is appreciated
Forecast Accuracy: Calculate the Category average based on percentages subcategories
Hello friends, I'm struggling with this issue for like a month, anybody could help me please? I have two tables: Forecast Table: Account Category Subcategory SubSubcategory Forecasted Value Actual Table: Account Category Subcategory SubSubcategory Actual Value I would like to calculate my forecast accuracy in two methods (like in the simplified table below) : - Weighted Average Accuracy (easy, I got this) - Non Weighted Average of the Subcategory Accuracies (in yellow) After this, I need to be able to filter the results by "Account" with a slicer on my dashboard. This will allow me to understand how well the Account has forcasted for each Category, Subcategory and the third is a KPI that kind of average the two. I think this could be done with some DAX VAR or GROUPBY but didn't manage to do make it right now.. Any ideas folks?
Average of Rates
I built out a table in powerBI to give me average of a series or rates. However, the average is wrong. I wrote out the new table like this: summarizecolumns(Sheet1[District],'Sheet1'[Fiscal Year],"Usage Rate",Average('Sheet1'[%Beds])) For example, district only has one hospital with a rate of 81.1% for a specific year. However, when I create the table for with "Usage Rate" by district for that specific year, the table reads 83.5. The table should have a rate fo 81.1 for one hospital in that district for that year . Since that average is wrong, I can safely assume the average is wrong for all other districts with multiple hospitals.
