User Profile
vivek_rana
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
- 11KViews0likes3Comments
Re: Average Growth Rate
Ashish_Mathur .- I have this Output right now, with month over month percentage difference calculated. Date(Month/Year) Amount MOM Percentage Difference May 2022 7468 -80% April 2022 36522 -38% March 2022 58872 190% Feb 2022 20301 -54% Jan 2022 43971 -55% Dec 2021 96699 I am trying to show Average of MOM Percentage Difference in a CARD. so I think output should be (-80+(-38)+190+(-54)+(-55))/5 = -7.40. Please correct me if i am wrong. Sharing Calculation for MOM Percentage Difference : MoM% = VAR Sum_CY = SUM ( Orders[Sales] ) VAR Sum_PY = CALCULATE ( SUM ( Orders[Sales] ), ALLEXCEPT (Orders,Orders[Category]), DATEADD ( 'Calendar'[Date].[Date], -1, MONTH ) ) VAR MoM = DIVIDE ( Sum_CY, Sum_PY ) - 1 Var Result = IF ( MoM = -1, BLANK (), MoM ) Return Result11KViews0likes8CommentsAverage Growth Rate
How to calculate Average growth rate over time Dax query Let say Number of milk cans sold by the company in the past four years: 2018 = 350 2019 = 450 2020 = 500 2021 = 650 Calculate the company's average annual growth rate. So, if the present value is 650, the past value is 350 and the number of years is 4, you get: Growth rate after 2018: (450 - 350) / 350 x 100 = 28.57% Growth rate after 2019: (500 - 450) / 450 x 100 = 11.11% Growth rate after 2020: (650 - 500) / 500 x 100 = 30% Average growth rate over time = (28.57% + 11.11% + 30%) / 3 = 23.22% per year Im struggling to get this in dax query . Please Suggest a method to get Average growth rate over timeSolved11KViews0likes12CommentsHow to Compare column and measure , when we don't have any relationship between the tables?
Hi Community, If i want to compare each date in the row in one table, with MAX (date) in the other table. But condition is - we can't have relation between both tables. If Close date > Max(Date) || Close Date is BLANK() then 1 ,0 here max (date) is from dim date table and close date is from second table. With no relationship between the tables. Lets say max( date) in dim _date table is 3/31/2021. I should get the Following output. ID Start Date Close Date Desired Output Current output A 12/1/2020 1/1/2021 0 0 B 1/1/2021 1 1 C 44228 1 1 C 44228 2/15/2021 0 0 E 44228 3/19/2021 0 0 F 44228 6/13/2021 1 0 G 3/1/2021 1 1 my dax: output = VAR M = MAX(dim_Date[Date]) var v2 = IF (Sheet1[Close Date] > Mmamm || Sheet1[Close Date] = BLANK(),1,0) Return v2 Excel link:- https://docs.google.com/spreadsheets/d/1S3d8We21wC25m_nc6GgFYxis5uA4WokL/edit?usp=sharing&ouid=103329800643314029916&rtpof=true&sd=trueSolved4.3KViews0likes4CommentsRe: Carry Forward NULL ID Count from previous months to Next Month
Hi Alexis, Thanks for writing back. I tried but that not working. If Jan month has a ID with null close date, how do we add that to the ID count of next feb month. so if id count for feb is 3, and jan has a null value. id count for feb should be 4.722Views0likes2CommentsCarry Forward NULL ID Count from previous months to Next Month
Hi, I am looking for Help on this issue:- We have a Table, with Start and close Dates. ID Start Date Close Date Count of ID A 1/1/2021 1/1/2021 1 B 1/1/2021 1 C 2/1/2021 2/15/2021 1 D 2/1/2021 2/15/2021 1 E 3/1/2021 1 We need to calculate the count of ID's at month level. For the Above Table output is :- Month Count Jan 2 Feb 2 March 1 But We have some ID's with NULL Close Date. Challenge:- We need to add those NULL ID count from one month to another. i.e If we have Null ID's in january, it should add to Feb count . If we have null in feb it should add to March count and so on.. Please find the desired Output needed:- Month ID Count Jan 2 Feb 3 (2 id's from feb and 1 null id added from January) March 2 (1 id from march , 1 null from Feb) excel on drive:- https://docs.google.com/spreadsheets/d/1zOIWyj1zXd0WKAGfVlxTf-tFF5EC9IwF/edit?usp=sharing&ouid=103329800643314029916&rtpof=true&sd=true Hopefully I get a Reply soon. Thankyou.Solved850Views0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.