Growth - Same period last year
Hello Everyone! I'm facing some difficulties in calculating the YoY Growth (sharing QTD sales vs the same period last year) I'm using the formula below to calculate the QTD Orders from this year, and the result is coming right QTD Sales = CALCULATE(COUNT('Orders'[Order Date]),DATESQTD(('Calendar'[ Date]))) The problem is in the formula that calculates the same period from last year: Last Year QTD Orders = calculate(count(Orders'[Order Date]),DATESQTD(DATEADD('calendar'[ Date],-1,YEAR))) It's bringing the result from the WHOLE quarter last year, not from the same period as this year (QTD) I've tried to calculate using the SAMEPERIODLASTYEAR and I got the same results. I don't know if the problem is in my calendar, which was built this way: Calendar = var mindate = year(MIN('Orders'[Order Date])) var maxdate = YEAR(MAX('Orders'[Order Date])) return ADDCOLUMNS( FILTER( CALENDARAUTO(), YEAR([Date]) >= mindate && YEAR([Date]) <= maxdate ), "Year", YEAR([Date]), "Month", FORMAT([Date],"mmmm"), "Month_Number", MONTH([Date]), "Quarter", FORMAT([Date], "\QQ" ) ) I already marked the calendar as date table. Thank you so much in advance
'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 RegardsYoY reduction in headcount based on annual percentage value
Hi, I am trying to calculate year over year reduction in headcount as per a given percentage value of previous year’s headcount. The logic is as follows: Initial Headcount = 10 Percentage reduction annually = 20% So, Headcount in 1st Year = Initial Headcount – (20% of Initial Headcount) = 10 – (20% of 10) = 10 – 2 = 8 Headcount in 2nd Year = Headcount of 1st Year – (20% of Headcount of 1st Year) = 8 – (20% of 8 ) = 8 – 1.6 = 6.4 Headcount in 3rd Year = Headcount of 2nd Year – (20% of Headcount of 2nd Year) = 6.4 – (20% of 6.4) = 6.4 – 1.28 = 5.12 Please help in doing the same! Thanks in advance!
