I need to findout monthly and year level growth% in the bar char, based on selection we need to show

[Sreelatha]

Type	Year	Month	Current_YTD	Previous YTD	YTD_Growth%
Book	2024	January		2755	-100.00%
Book	2024	February		2457	-100.00%
Book	2025	January	1853
Book	2025	February	3222
Pen	2024	January		875	-100.00%
Pen	2024	February		879	-100.00%
Pen	2025	January	1625
Pen	2025	February	1746

Hello Everyone— I’m getting -100% for 2024 rows and blanks for 2025 rows when calculating YTD growth. My expectation is to compare the same month across years (e.g. 2025 Jan vs 2024 Jan) per Type
My concern is , i need to show the values and Growth% in the same row and growth should be correct value for every year and month

[v-ssriganesh]

Hello @Sreelatha, 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[v-ssriganesh · Accepted solution]

Hello @Sreelatha,
Thanks for your patience.

I reproduced your scenario in Power BI Desktop using the same structure you shared and got the expected output, and the issue occurs because the model needs a proper Date table and a measure that retrieves the same Type and same Month from the previous year. Without this, Power BI returns values like -100% for 2024 and blanks for 2025.

For your reference, I am attaching the .pbix file that contains the full working solution so you can review and compare it with your model.

Best regards,
Ganesh Singamshetty.

[Sreelatha]

My issue is still not resolved. If anyone among you can help me, it would be useful for me.

[v-ssriganesh]

Hi @Sreelatha,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Praful_Potphode, @Jihwan_Kim & @amitchandak for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[Sreelatha]

My issue is still not resolved. If anyone among you can help me, it would be useful for me.

[Praful_Potphode]

Hi @Sreelatha ,

if you want to show 2025 Jan vs 2024 Jan then you have to create current month,previous month and mom%.

refer sample pbix for reference.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Jihwan_Kim]

Hi,

I am not sure whether the below is what you are looking for, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Sales: = 
SUM( sales[sales] )

Sales YTD: = 
CALCULATE (
    [Sales:],
    WINDOW (
        1,
        ABS,
        0,
        REL,
        ALL ( 'Calendar'[Year], 'Calendar'[Month name], 'Calendar'[Month number] ),
        ORDERBY ( 'Calendar'[Month number], ASC ),
        ,
        PARTITIONBY ( 'Calendar'[Year] )
    )
)

Sales YTD prev year: = 
CALCULATE (
    [Sales YTD:],
    OFFSET ( -1, ALL ( 'Calendar'[Year] ), ORDERBY ( 'Calendar'[Year], ASC ) )
)

YTD Growth %: = 
VAR _currentyearYTD = [Sales YTD:]
VAR _prevyearYTD = [Sales YTD prev year:]
RETURN
    DIVIDE ( _currentyearYTD - _prevyearYTD, _prevyearYTD )

[amitchandak]

@Sreelatha , make sure you fact is join with date table that is marked as date table 

and you can measures lik

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.