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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
bgiri2430
Frequent Visitor

Need to create rate difference like rate_2023 - rate_2022 through dynamic

Trying to create like below :- 

16899235671247194636957300576956.jpg

2 REPLIES 2
Anonymous
Not applicable

Hi @bgiri2430 ,

You can refer the following links to get it:

Field parameter:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Mastering field parameters in Power BI | A practical and common use case - Bing video

vyiruanmsft_0-1690177872978.png

Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update] - Bing video

vyiruanmsft_1-1690178097187.png

 

If the above one can't help you, could you please provide some raw data in your table 'LTSS_PIVOTED', 'PRIOR RUN' and 'CURRENT RUN' (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

bgiri2430
Frequent Visitor

Please help

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.