Weighted Variance - Help please?
I have a lot of history data and I'm trying to determine both the overall weighted variance amongst all employees as a whole, but also find out each individuals weighted variance. Averages and a lot of other data i've managed to figure out. Weighted variance, however, is very complicated. Can someone lend a hand with the right measurements? I'd greatly appreciate it. I can upload a sample of the data if needed. I just took a SS and posted it to show you what it looks like.Quarter over Quarter variance measure/column for table with quarter end amounts by account.
I have a table that lists quarter-end account balances by account and business group and I'd like to create a measure or column that shows the quarter-over-quarter balance change for each company/account combo (e.g., Group A, Account 10000 quarter-over-quarter change is $500 in Q2). I've tried various formulas using the calculate function, but these don't work if I don't apply aggregation (SUM and SUMX are what I've tried) to the AMOUNT column. The aggregations seem to mess up the results. I either get blank values or duplicate amount values. I think it's because the amounts don't need to be aggregated. They're already aggregated values. How can I do a simple subtraction based on quarterly dates without having to aggregate my amount column? The formula(and similar variations) I've tried: VAR CurrentAmt = TABLE1[AMOUNT] VAR PrevAmt = CALCULATE(SUM(TABLE1[AMOUNT]), PREVIOUSQUARTER(TABLE1[DATE].[DATE]) RETURN = CurrentAmt - PrevAmt Table example: Group Account Q End Amount Quarter A 100000 $2000 3/31/22 A 200000 $3000 3/31/22 B 100000 $4000 3/31/22 B 200000 $5000 3/31/22How to show parking slot availability using SVG image
Hi, Need urgent help and suggestions please. This is related to using SVG and creating measure for desired result on SVG. Problem Statement: On my Parking Dashboard, I want to depict a Parking Lots' slot availability (by color, green and red) using its SVG image. I have understood that I can write VAR measure to fill the slots colors. Color would depend on values for each parking slot that I am getting from a certain table and column. The first pic is for the svg to be filled. The second image is the result. The colors would be dynamic and would keep on changing as per slot availability real time. I want to understad if this is possible to achieve via approach of DAX formula (VAR) on svg images? And if there is a simpler way to achive end result? My inspirations for the solution were below links: https://www.youtube.com/watch?v=z7eyZM2b4Z8 https://www.kasperonbi.com/showing-kpis-in-a-table-or-matrix-with-power-bi/ Thanks in Advance, Priyanka
Price Volume Effect with customizable timeperiod, and dynamic with rest of dataset
Hi, Hope there are anyone who could/would like to help me with a question I have related to PVM analysis with customizable time period, and dynamic with the rest of the dataset at the same time. I have a whole dataset with different business-related data (customer, product, order), all connecting to one sales table through relations and separate DimKeys. What I would like to do is to create a price volume mix measure which calculates on a product level. I have seen many solutions to do this by using VAR and order. But the problem is that all of the once I have seen relates to Current Years vs Previous Year. I would like to create a model which allow me to use any two periods I would like. For example, the PVM analysis on a product level for year 2016 vs year 2020 (not 2016 to 2020) or March 2018 vs. June 2019 and so on. On other words: A PVM analysis on a product level with any two different time baselines, which is connected to the rest of that data set and changes dynamically according to filters such as customers or product segment. I would like to make the end user be able to choose any start and end period for the PVM calculation, directly in the Dashboard. Is there a way to do so? Or is there a constraint on the time period which makes it difficult? Thank you very much.Budget Variance - Multiple Slicers
Main Scope The main idea is to create a price variance between the selected reports, within the selected time frames. The user of the dashboard will: 1) Select the current budget and period 2) Select the comparing budget and period Data Setup The sample dataset contains of the following data: The Main Data: - Reports (Categorical variable for the different budget) - DimDate (Date of expected invoicing) - Net Sales - Units Besides, I created two seperate tables that are not connected to the Main Data: Slicer1 = VALUES('Main Data'[Report]) Slicer2 = VALUES('Main Data'[Report]) Current Problem: To create a measure for price variance I will need to create a measure for units and net sales that 1) filters for the selected budget and period in the current period 2) filters the selected budget and period in the comparing period 3) gives the variance of the above selections Initially, I created a measure that filters only the selected budgets based on the selections of the budgets: Unit = VAR units = calculate(sum('Total Data Table'[Invoiced Units]), filter('Total Data Table','Total Data Table'[Report]=SELECTEDVALUE(slicer1[Report]) || 'Total Data Table'[Report]=SELECTEDVALUE(slicer2[Report]))) RETURN if(HASONEVALUE('Total Data Table'[Report]),units, CALCULATE(sum('Total Data Table'[Invoiced Units]), filter('Total Data Table','Total Data Table'[Report]=SELECTEDVALUE(slicer1[Report])))- CALCULATE(sum('Total Data Table'[Invoiced Units]),filter('Total Data Table','Total Data Table'[Report]=SELECTEDVALUE(slicer2[Report])))) This formula does not filter for the selected period, only the selected budgets. I would like to compare different budgets accross different periods. For Example: - Compare Budget 1 in period 01/01/2019 - 12/03/2019 - To Budget 2 in period 01/07/2019 - 12/09/2019 I have tried multiple ways to do this, but have not found any that worked; I hope a smart solutions exists to this issue.
Categorising Variances
Hello everyone - I'm looking for some support with a DAX problem. I have a table of results showing project details taken at various points in time (e.g. Project ID, Site Code, Start Date, Value), and the intention of the report I'm building is to measure any changes which have occurred between two points in time. My data has an 'export date' field of when the data was taken, and so far I've successfully create a report which allows two dates to be selected using slicers then produces a table of results showing the changes which have occurred along with a descriptive categorisation (i.e. New Project Created, Project Removed, Start Date Change, Value Change). Although this achieves my initial goal of measuring the changes, all the results are shown individually in a table view and what I also need to be able to do is present a dashboard view that answers more high level questions such as 'How many projects were delayed?' and 'How many projects have been added?'. So far the only way I've found of achieving this is to create a summarized table and then recreate the categorisation measure as a calculated column, however the main limitation of this appears to be that I can only use static dates, and not the slicer selections. The below link includes a crude mockup of the PBIX that I'm working on. Link: Categorising Variances PBIX Any support that anyone can offer would be warmly welcomed 😊
