Hi, I am using Analysis Service and I have a calculation group for time intelligence.
I have this Measures in the calculated group:
Actual = CALCULATE( SelectedMeasure() , DATESMTD( 'DWH DimDate'[Date] ))
Acc = CALCULATE( SelectedMeasure(), DATESYTD( 'DWH DimDate'[Date] ))
Then i have this measures:
FactActual = sum('DWH FacVentas'[Facturacion Cliente])
FactMonth-1 = CALCULATE( sum('DWH FacVentas'[Facturacion Cliente]) , Dateadd( 'DWH DimDate'[Date],-1,MONTH ))
FactYear-1 = CALCULATE (
sum('DWH FacVentas'[Facturacion Cliente]),
SAMEPERIODLASTYEAR ( 'DWH DimDate'[Date] )
)
all is working well when I select Month or Acc from calculation group except FactMonth-1
When from the DimDate i Have selected for example February 2023, the Acc fro FactMonth-1 should return only the sum of January 2023. However, the ACC measure is returning the Sum of January 2023 and December 2022.
When I select March 2023, the same, it should return only January and February 2023 sum, but always is suming December 2022 as well.
FactYear-1 when I select Acc is working fine!
thanks for your help.
