Variance between Two Years on same Date Axis using same Amount Column
Unfiltered: Filtered: The task at hand is simple, take the 2025 values (Food Revenue, Beverage Revenue, etc.) and subtract the 2024 values from the correlated field (first screenshot). However, I am running into issues with the date axis it lies on and how to correctly display only the months needed. The formula used takes the sum of the current year (CY, Dec 2024 - Mar 2025) for a specific account, and subtracts it from the balance of the prior year (LY, Dec 2023 - Mar 2024). This does in fact work, as the values shown in the second screenshot are correct for Food Revenue Variance for the months needed thus far (fiscal year starts in December, so December 2024 - March 2025). However, when I filter to just show the months needed, the values revert to only show the balances correlated with the current year (CY). Any ideas on how to show this variance correctly? In layman's terms, basically need to INCLUDE data from all months relevant (Dec 2023 - Mar 2024, Dec 2024 - Mar 2025), but I only need to DISPLAY the months with the correct values for variance (Dec 2024 - Mar 2025). DAX measure: VARI Food Revenue = VAR CY = CALCULATE(SUM(ConsolidatedReport[Amount]), ConsolidatedReport[GLAccount] = "450000", DateDim[CurrentFiscalYear] = 0) VAR LY = CALCULATE(SUM(ConsolidatedReport[Amount]), ConsolidatedReport[GLAccount] = "450000", DateDim[CurrentFiscalYear] = -1, REMOVEFILTERS(DateDim[Date].[Year])) RETURN CY - LY
Calculating Variance between two categories and month
Hello, I am seeking to find the fuel price (last column) variance between DOM and FTZ (third column) for each month and year. I have tried a variety of calculations, including the Quick Measure feature, however, am still struggling to find the proper solution. My apologizes if this is an easy fix as I am still new to PowerBi. Clarification: All the data below lives in one table titled "WIP Table" Thank You!Variance for Workday Last Month
Hey Everyone, I am trying to get an order count variance based on the working day last month. Here is an example of the data I would like to see. Date /Working day /Count /Previous month workday count /difference 08/19/21 14 105 305 -200 07/21/21 14 305 205 100 06/18/21 14 205 Blank() if no data Blank() if no data 08/18/21 13 150 450 -300 07/20/21 13 450 300 150 06/17/21 13 300 Blank() if no data Blank() if no data I have tried so much and just can't seem to get the data to look like this. If you have a measure to grab the last months working day order count that would be amazing if you can share it. Thats the hardest part for me. Thanks!
Variance measure, how to make it work with date hierarchy e.g. Month / Quarter / Year
Hi, I have the following measure DCM Month to Month Variance % = DIVIDE( [DCM], CALCULATE( [DCM], DATEADD('Calendar'[Date], -1, MONTH ) ), 0 ) -1 This works great for showing the month to month variance of the DCM measure. What I want to do is to be able to drill down through Month > Quarter > Year and have the measure adjust to that time period accordingly. What I am trying to avoid is having 3 charts displaying this i.e. one of month variance, one for quarterly variance etc. Is this possible to do?
Monthly Report with Last Month's Variance Only
Hello! I'm certain this question has been asked a million times but all of my searching brings up the 1,000's of requests for a simple MoM variance. I've got that part handled. I'd like to show a more streamlined matrix though with several months of data with variance only for the prior 2 months. I'm trying to build a report that looks like this: Here's what I currently get: Is there an "IsFiltered"-type pattern that will let me only show the variance once for the current month and supress it for all prior periods? Alternatively, is there a way to leave the calcs all the same but visually hide the prior month variances? Or, since I'm a finance/Excel "guy", maybe I should be showing this in some other more visual way and simply recreating my Excel Pivot Table in Poewr BI is just plain lazy... Thanks in advance! Here's the DAX: Current month Invoices By Category (w Pmts) = VAR InvoiceAmt = [Total Invoice Amount] + [Total Pmts Revenue] RETURN IF( [BrowseDepth] > [MaxNodeDepth] + 1, BLANK(), IF( [BrowseDepth] = [MaxNodeDepth] + 1, CALCULATE( InvoiceAmt, FILTER( VALUES( Items[IsLeaf] ), Items[IsLeaf] = FALSE ) ), InvoiceAmt ) ) Last Month: Invoices By Category (Last Month) = CALCULATE( [Total Invoices By Category], PREVIOUSMONTH('Calendar'[Date]) ) Variance: MoM Invoice & Pmts Variance = [Invoices By Category (w Pmts)] - [Invoices By Category (Last Month)] - [Pmts Revenue Last Month]
