Forum Discussion
Incorrect Summarize in Matrix
Hi azaterol ,
I updated your sample pbix file(see the attachment), please create another new measure as below to replace the measure [previous year] onto the matrix:
Measure = SUMX ( GROUPBY ( 'Date', 'Date'[Year], 'Date'[MonthNameShort] ), [previous year] )Best Regards
azaterol , Try measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
Hello amitchandak ,
this is not working. I uploaded an example. As you can see, 3 is entered as the sum for previous year. For 2022 in the previous year column there should be a 4 and not a 3. For 2021 previous year there has to be an 18. And at the bottom as a total is also 3, here must be 22. Quantity is a column. previous year is a measure.
Here the measure:
previous year = CALCULATE(SUM('Order'[Quantity]),FILTER(ALL('Date'),EOMONTH([Date],0)=EOMONTH(MAX('Date'[Date]),-12)))
How it should be:
Can you help me here?
Hi azaterol ,
I updated your sample pbix file(see the attachment), please create another new measure as below to replace the measure [previous year] onto the matrix:
Measure = SUMX ( GROUPBY ( 'Date', 'Date'[Year], 'Date'[MonthNameShort] ), [previous year] )Best Regards