Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
drivero
Helper I
Helper I

Calculated Group problem

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.

0 REPLIES 0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Kudoed Authors