Solved: How can I calculate prior year (PY) sales in Power BI for a matrix table, where the Month column (from the SalesOrderHeader table) is on the
Down below I have my company's sample sales report. I'm trying to achieve the following: -In the red square, when a value is selected, the title, instead of "Month-1, Month-2", replace with "12/31/2022, 11/30/2022 etc..) Here's what I've done: -I'm using field paramater...
I have created the following calcualtion which correctly shows the total in the previous year through the current month, but shows the entire month, not to-date: PY YTD Net Sales =CALCULATE(SUM(Sales[NET SALES]),FILTER(ALL('Date2'),Date2[YEAR] = (YEAR(NOW())-1)&& Date2[MONTH NUMB...
Previous Year Sales (current month) = VAR Calc = CALCULATE([Sum of Sales], FILTER(DATEADD('Calendar Table'[Date], -1,YEAR), MONTH('Calendar Table'[Date]) = MONTH(TODAY())) RETURN IF(MAX('Calendar Table'[Year]) = YEAR(TODAY()), Calc) 2) I need 2019 Total Year Sales ...
Sales with 6 month Disply.pbix AT TI.pbix Message 4 of 6 1,142 Views 0 Reply Helpful resources Announcements Join us at the Microsoft Fabric Community Conference March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Register now Microsoft Fabric...
Sales with 6 month Disply.pbix AT TI.pbix Message 4 of 6 1,135 Views 0 Reply Helpful resources Announcements Join us at the Microsoft Fabric Community Conference March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Register now W...
I'm trying to make a table/matrix that compares account counts in the current month to the prior month, and to the prior quarter end. And then calculating the count difference, and the % difference. Also I'd need a slicer that can change what the "Current" month is, so if...
I am able to use a dynamic month measure to get individual month and VPM calculate but I only managed to present using the following layout : Dec-20 Jan-21 Feb-21 Customer Sales VPM Sales VPM Sales VPM A 12 10 -2 9 -1 B 10 11 1 12 1 C 8 9 1 9 0 May I ask are there ...
"Year Month number", FORMAT ( [Date], "MM-YYYY" ), "Month Name Long", FORMAT ( [Date], "mmmm" ), "Day of Week Number", WEEKDAY ( [Date] ), "Day of Week", FORMAT ( [Date], "dddd" ), "Quarter", "Q" & FORMAT ( [Date], "Q" ), "Year Quarter", FORMAT ( [Date]...
Basically it takes the Actual Amount from the Sales Table if the Month is an Actual Month and it takes the Forecast value from the Sales Forecast table, for a Forecast month divided by three. Hope this helps Regards Did I answer your question? Mark my post as a solution, this...