YTD YOY measure without a date table
Hi! I have a matrix viz in my sales report that lists the sales years and months for our teams' vendors. One of the asks is to 1) filter the total sales for 2024 and 2023 for YTD based on the month, and 2) create YOY and YOY% columns based on YTD. I know how to do this with PBI's time intelligence functions, but the issue is the data comes only as months and years so there's no date columns. I tried to first make a calculated column finding the max month for 2025, then using that in the YOY measure to either look at 2024 or 2023 depending on what sales year you're lookign at. But it's only returning the actual sales amounts. any insight is appreciated - I would prefer this to be dynamic for any years. YTD = var maxmonth = MONTH(TODAY()) RETURN IF('Total Vendor'[MonthNum] <= maxmonth, "Y", "N") YTD YOY = var curryear = 2025 var ty = CALCULATE(SUM('Total Vendor'[sales]), 'Total Vendor'[YTD]="Y") var ly = IF(MAX('Total Vendor'[Year])=curryear, CALCULATE(SUM('Total Vendor'[sales]), 'Total Vendor'[Year] = 2024,'Total Vendor'[YTD]="Y"), CALCULATE(SUM('Total Vendor'[sales]), 'Total Vendor'[Year] = 2023,'Total Vendor'[YTD]="Y")) return ty-ly
YoY Growth Card
Hello, I have created the measure to calculate yoy growth. VAR _CY = [Total Order Volume] VAR _LY = CALCULATE( [Total Order Volume], DATESBETWEEN( Calendar_Table[Date], EDATE(MIN(Calendar_Table[Date]), -12), EOMONTH(MAX(Consolidated_Order_Book[ReceiveDate]), -12) ) ) VAR _Check = _CY && _LY && HASONEVALUE(Calendar_Table[FY_Year]) VAR _Growth = IF(_Check, DIVIDE(_CY,_LY) -1) RETURN _Growth The output is giving me the desired result when presented in a graph or table However, I wish to take this a step forward by presenting the growth rate for the current year in a card dynamically without applying external filters. which I have failed to achieve because the care is returning blank. Please advise the changes I need to make in the measure to pick the growth rate for FY-25 only. The financial year in the calculation begins in April and ends in March.
YoY% but with a rolling date
So I have a quick measure that looks at YoY% but I need to have it as a rolling date (automated so it sees that the date is different so if reflects the date) so look at today's date but last year's (2022), the year before (2021), and the year before (2020). Count of Reporting Number YoY% = IF( ISFILTERED('Initial Data'[Date_and_Time]), 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( COUNTA('Initial Data'[Reporting Number]), DATEADD( 'Initial Data'[Date_and_Time].[Date], -1, YEAR ) ) RETURN DIVIDE( COUNTA('Initial Data'[Reporting Number]) - __PREV_YEAR, __PREV_YEAR ) )
How to get Mom, QoQ and YoY% calculation change
Hi All, I have a question on how to calculate Mom, QoQ and YoY% change and then use it on line and clustered column chart. My data somewhat looks like this. So, for 2022 Mar to 2022 April the sales got increased from 7891 to 9623, I need that to show as MoM percentage growth and similarly for the rest. Can anybody please help me with this? Year Quarter Month size 2022 Qtr 1 March 7891,78 2022 Qtr 2 April 9623,21 2022 Qtr 2 May 6853,63 2022 Qtr 2 June 1528978 2022 Qtr 3 July 195737,1 2022 Qtr 3 August 168077,9 2022 Qtr 3 September 294695,8 2022 Qtr 4 October 23159,34 2022 Qtr 4 November 214343 2022 Qtr 4 December 42684,12 2023 Qtr 1 January 150256,5 2023 Qtr 1 February 167633,6 2023 Qtr 1 March 167716,5How to Compare Year over Year if there is Data inconsistency?
I have 3 years orders data. 1st year has data starting from 14th week, 2nd year 53 weeks data, 3rd year has only 9 weeks data. In this case how can I calculate YoY. Obviously, if I use YoY quick measure it will show negative value. How do I approach this situation? Download Pbix file from below link. Also, provide few recommendations on how can I impove my report. Blinds Pbix Thanks in Advance.
Year-Over-Year calculation
Hi Everyone, I am completely new to Power Pivot and DAX calculations. I have a simple data model with a date table and a fact table with dates and sales generated per date. Each month, I am generating a report that shows MTD and YTD sales vs Last year for the same period. Is there a DAX formula to show this.
