Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mayurpawar0305
Regular Visitor

I want to show two months data percentage and their difference

‎02-13-2023 10:03 AM

In this case I need two months data percentage and after that their difference.

For that I have created a slicer by clicking on month it will result into selected month and previous month percentage.

 

"Months to Show =

    Var Max_Date = MAX('Calendar' [Date])

    Var PreviousDates = DATESINPERIOD ('Calender Months to Display'[Date],Max_Date,-2, MONTH)

    Var Result =CALCULATE([Total_1 %],
        REMOVEFILTERS('Calendar'),
        KEEPFILTERS(PreviousDates),
        USERELATIONSHIP ('Calendar' [Date], 'Calender Months to Display'[Date]))

Return Result"

 

 This dax will giving two months data.

I need difference column in that. Please help me !

 

ProductDec'22Jan'23Diff
Mobile85.41%84.62%-0.78%
Laptop14.59%15.38%0.78%
AC3.11%3.22%0.11%
Tv3.02%3.20%0.18%
Bike1.62%1.73%0.11%
Computer1.01%1.10%0.08%
Car0.97%1.12%0.15%

 

Labels:
Message 1 of 1
287 Views
0
0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All