Power BI Adoption Strategy - June 2022
This June, we're excited to announce that we have a remote guest speaker, DeNisha Malone from Microsoft, talking to us about Power BI adoption strategies. This session will present attendees with a set of roles, responsibilities, and behaviors that have been developed after working with customers in real-world Power BI deployments. DeNisha will share Microsoft’s Adoption Framework and how it can benefit the growth of application use in an organization. The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm on Wednesday June 8th. About the Speaker: DeNisha Malone, formerly known as “the Power BI Queen”, is an Intelligence Platform Program Manager at Microsoft. She is known for her knowledge in data-storytelling and Power BI administration strategies. DeNisha’s work has improved user acceptance and the adoption of Microsoft’s Power BI in enterprises all over the world. She enjoys sharing to user groups and helping small businesses migrate from manual Excel reporting to optimized Power BI tenants. More of her hobbies include reading self-help books, mentoring, and traveling the world experiencing new things. ***UPDATED LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. This is where we met in November. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutateIncorrect Achievement & Growth Percentage
there are 2 table table first is correct and 2nd is showing incorrect result when calculation in power bi i am using below dax formula %'Ach'Jan25 = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Jan'25],0) %'Grth'Jan = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Ach_Jan24]-1,0) Ach_Jan25 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2025" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0) Ach_Jan24 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2024" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0)
Calculate % Growth change on the basis of Selected Period
Hi All, I am struggling to find the soultion for the below problem statement. I have to create a measure to calculate the %change from selected quarter range. For example, we have data of 2023 from each month with salesDate. @Greg @HotChilli @bhanu @bhanu_gautam @lbendlin @Irwan Many Thanks
Quarterly Growth Calculation
Hello! I'm calculating the average growth rates of some sale values for each quarter. I had to convert the quarters into numeric values to get it to work though. Here is the measure I used: Growth Rate from Average Sales = VAR CurrentQuarter = MAX(Assets[Quarter]) VAR CurrentQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = CurrentQuarter) VAR PrevQuarter = MAX(Assets[Quarter]) - 1 VAR PreviousQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = PrevQuarter) RETURN IF(ISBLANK(CurrentQuarterSales) || ISBLANK(PreviousQuarterSales), BLANK(), DIVIDE(CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales)) Here is the data: Sales Quarter Qlabel 454 4 Q4 2022 326 4 Q4 2022 542 3 Q3 2022 542 4 Q4 2022 653 3 Q3 2022 553 2 Q2 2022 535 2 Q2 2022 554 2 Q2 2022 553 1 Q1 2022 985 4 Q4 2022 696 4 Q4 2022 662 4 Q4 2022 366 3 Q3 2022 365 1 Q1 2022 665 4 Q4 2022 363 3 Q3 2022 352 1 Q1 2022 233 4 Q4 2022 352 1 Q1 2022 524 2 Q2 2022 235 4 Q4 2022 241 3 Q3 2022 545 1 Q1 2022 658 3 Q3 2022 654 4 Q4 2022 354 3 Q3 2022 365 4 Q4 2022 1000 1 Q1 2022 545 3 Q3 2022 985 2 Q2 2022 654 1 Q1 2022 354 1 Q1 2022 When I turn it into a visualisation it shows the quarter as a number (1 instead of Q1 2022). Is there any way of calculating the growth and then in the visualisation showing the % growth against the quarter as written in the Qlabel column (Q1 2022)? Here is the visualisation currently. the row marked as "4" is the growth from Q3 2022 to Q4 2022.
Growth - Same period last year
Hello Everyone! I'm facing some difficulties in calculating the YoY Growth (sharing QTD sales vs the same period last year) I'm using the formula below to calculate the QTD Orders from this year, and the result is coming right QTD Sales = CALCULATE(COUNT('Orders'[Order Date]),DATESQTD(('Calendar'[ Date]))) The problem is in the formula that calculates the same period from last year: Last Year QTD Orders = calculate(count(Orders'[Order Date]),DATESQTD(DATEADD('calendar'[ Date],-1,YEAR))) It's bringing the result from the WHOLE quarter last year, not from the same period as this year (QTD) I've tried to calculate using the SAMEPERIODLASTYEAR and I got the same results. I don't know if the problem is in my calendar, which was built this way: Calendar = var mindate = year(MIN('Orders'[Order Date])) var maxdate = YEAR(MAX('Orders'[Order Date])) return ADDCOLUMNS( FILTER( CALENDARAUTO(), YEAR([Date]) >= mindate && YEAR([Date]) <= maxdate ), "Year", YEAR([Date]), "Month", FORMAT([Date],"mmmm"), "Month_Number", MONTH([Date]), "Quarter", FORMAT([Date], "\QQ" ) ) I already marked the calendar as date table. Thank you so much in advance
