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...
IF('Calendar'[Month number]>=4,"Q1","Q4"))) As mentioned, however I do not have an issue in calculating sales or % change for prior quarter - I got a measure that works fine. What I need is the text reference to the prior quarter which I need to put into a card's subtitle ...
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 ...
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 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date])) or a measure like 1 year behind = var _max1 = maxx(ALLSELECTED('Date'),'Date'[Date])var _min1 = Minx(ALLSELECTED('Date'),'Date'[Date]) var _max = date(Year(_max) -1, month(_max), ...
I modified your formula for the example below, I always got "Yes", because the DATEADD command (specifically --> calculate ( sum ('Table'[Sales]),dateadd ('Table'[Period],-1,MONTH)) -- seems to be returning a value of zero, when it should be -400 (for ABC, Jul ...
The problem is how do I get the inventory as of a prior month ( or date) i.e Jan 2022. The records that need to be considers are from Jan 1, 2020 ( as I do not need to go back more than 3 yrs). I am able to get the result by filtering the rows in a visual. How can ...
The problem is how do I get the inventory as of a prior month ( or date) i.e Jan 2022. The records that need to be considers are from Jan 1, 2020 ( as I do not need to go back more than 3 yrs). I am able to get the result by filtering the rows in a visual. Ho...