Year Over Year measure incorrect for current year but correct of past year.
YoY measure is incorrect and saying +18% despite the balance being lower than last year? the QoQ measure works and is exactly similar except of course based off quarters. EnterDate Account Balance date Acct# $ date Acct# $ date Acct# $ date Acct# $ OpenBalance YoY% = VAR __PREV_YEAR = CALCULATE( SUM('MasterTableJ'[OpenBalance]), DATEADD('MasterDate'[Date], -1, YEAR) ) RETURN DIVIDE(SUM('MasterTableJ'[OpenBalance]) - __PREV_YEAR, __PREV_YEAR) MasterDate table is marked as date table
Show value for all months for previous years by default with current year values on graph
Hi, I am trying to show values for all months for prior/previous years with the data for current year based on a year slicer. The issue is that the x-axis range always gets dictated by the most up-to-date values (for the current year). See first screenshot I have tried several versions of previous year measures based on DAX (using DATEADD/PARALLEL PERIOD, ALLEXCEPT and ALL SELECTED) but cannot make it to show all months for previous years. Desired output shoud have all the values from 2021 (black line on second image) with the current values for 2022 (black line on first image). Any help would be appreciated.'Excess' Data when using YoY and QoQ measures
Hello, I am trying to get some analytical output for my report using QoQ and YoY measures in Power BI. But when put into a figure it displays data I do not need to show. My question is then, how can I limit the 'output' of my measures to fit what I need? QoQ Measure: Volume_In QoQ_Nominal = IF( ISFILTERED('Date'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_QUARTER = CALCULATE( SUM('DATA'[Volume_In]), DATEADD('Date'[Date].[Date], -1, QUARTER) ) RETURN __PREV_QUARTER ) YoY Measure: Volume_In YoY_Nominal = IF( ISFILTERED('Date'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_YEAR = CALCULATE( SUM('DATA'[Volume_In]), DATEADD('Date'[Date].[Date], -4, QUARTER) ) RETURN __PREV_YEAR ) !To be noted: The Data I work with is within the period Q1 2019 to Q2 2021, and I am using a slicer to define the quarter I want to see, which can be seen to the right. Now, the problem is, that too much (and too little) data is shown in my figure (below): 1: The Chart is filtered using the beforementioned slicer. Though I would like it to show the QoQ and YoY values as they are available and will strengthen my output (this also applies for YoY values for all 2020 quarters in the figure). How can this be done? 2: I am only working with 'current' data in the sense that I only want to show actuals data from full quarters. When I choose to show data up until Q2 2021 in my slicer, I do not want the figure to show the YoY measure for Q3 and Q4. How can this be done? I hope I have explained my problem well enough for you guys to understand! Kind Regards
Quarter + Year Text field to date field AND QoQ/YoY calculation
Hello, I am trying to find a solution to my problem. I will try to explain it as detailed as possible. 1. I have tried to link my uploaded Excel file to a date table. The Excel file contains the following "time dimension", but it is recognized in powerbi as text format: !NB note that there is more than one operator, meaning the quarters are repeated through the table. This is linked to a datetable with a cardinality relationship many-to-many through a custom Quarter+Year colum in the datetable: My first question is: Is this a correct of linking the two table, and if not what is best practice to do this? Second (which might be a consequence of not using best practice in first topic) is: when I try to calculate QoQ or YoY I am running into problems. I am trying to use a DATEADD function as this seems to be recommended several times on this community. when calculating Last quarter im using this dax formula: LastQ = CALCULATE([Value],DATEADD('Date'[Date],-1,QUARTER) ) and last year: LY = CALCULATE(sum('2 2 1 Pivot Data (2)'[Værdi]), DATEADD('Date'[Date],-4, QUARTER)) when putting the measures into a table with my original values I dont get any values in my table only when it sums up, meaning I can not make a measure calculating the difference between the quarters, I have tried it and it did not work. I am stuck and would very much appreciate if anyone have had the same issues and can help!
Last Year (LY) Measure Limited by Current Date
Hello All: Would someone help me to build a measure [Sales 2018] that shows last year amount for a selected period? In the example attached to this post, [Sales 2018] for June should be $34.7 M (June 1 - 25), not $42.6 M (sum through June 30, 2018). If I select, for example, May and June [Sales 2018] should be the amount from May 1 through June 25, 2018. And so on. The solutions I've seen so far focus on YTD calculations and are quite confusing. I am trying to build a measure with dynamically changing date rage based on the selection. Thank you all in advance. Alex
Year over Year calculation
I am trying to achieve a YoY calc with values from same table. I currently have a table as a visual where you can see the the years in columns with respective info. I have tried PARALLELPERIOD (year -1) and SAMEPERIODLASTYEAR, but data does not show properly, sometimes shows blanks. The goal is to have it work dynamically when you switch years and Fiscal Months. The Time filters would determine the date range and I would need -1 date info for that time period. Has anyone solved this before?
