'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
HELP - Average over QoQ% quick measure
Hi all! 🙂 I've just calculated, using a quick measure method, a Quarter over Quarter percentage change. If it's true that I got the desire result as is showing on the following table , I'd like the average percentage change by year and the total (for all the years). For example: the average of Q2 (Trim 2 in spanish), Q3 & Q4 for the year 2018 (being the data 3,50%, 3,99% and -55,11% respectively) is -15,87% and not -13,35% as is noted on the total summarizing. In the following image, I show you how is that I've performed the quick measure. P. S. I've changed the SUM of value by Average, MIN, MAX, etc... but the issue stills 😞 Thanks a lot!! 🙂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!How to create a measure for Quarter Over Quarter Calculation for Non Calendar FY and FQ?
Hello, The QoQ example given is for unconventional QoQ dates. I'm not sure how to calculate Amount differences and Percentages in Power BI for QoQ, because the dates in Power BI are created for Calendar Years. I don't have time intelligence dates just the FY and FQ and total sums. Appreciate any help with this.
