@indianparadisetrainer Is this also ok? Genral DAX - Calculate(SUM('Table'[Data]), DATESINPERIOD('Table'[Month_End_Dax], Max('Table'[Month_end_Dax]), , MONTH )) **[Month_End_Dax] - Date column. ** Rolling Period - Put -3, -6, -9 & -12.
@@indianparadisetrainer Why are we dividing in P3M (previous or past 3 months) dax measure by 3 , will it give Average 3 months sales? I means, Are these following measure correct if i am not wrong 1. P3M i. P3M (Previous or Past 3 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -3, Month)) ii. P3MAverage (Previous or Past 3 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -3, Month)) / 3 or i. P3M (Previous or Past 3 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -3, Month)) ii. P3MAverage (Previous or Past 3 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -3, Month)) / 3 2. P6M i. P6M (Previous or Past 6 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -6, Month)) ii. P6MAverage (Previous or Past 6 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -6, Month)) / 6 or i. P3M (Previous or Past 6 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -6, Month)) ii. P3MAverage (Previous or Past 6 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -6, Month)) / 6 3. P9M i. P9M (Previous or Past 9 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -9, Month)) ii. P9MAverage (Previous or Past 9 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -9, Month)) / 9 or i. P9M (Previous or Past 9 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -9, Month)) ii. P9MAverage (Previous or Past 9 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -9, Month)) / 9 4. P12M i. P12M (Previous or Past 12 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -12, Month)) ii. P12MAverage (Previous or Past 12 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -12, Month)) / 12 or i. P12M (Previous or Past 12 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -12, Month)) ii. P12MAverage (Previous or Past 12 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -12, Month)) / 12
Sir,can we use date add function for last 3 months sales?
@indianparadisetrainer Is this also ok?
Genral DAX -
Calculate(SUM('Table'[Data]), DATESINPERIOD('Table'[Month_End_Dax], Max('Table'[Month_end_Dax]), , MONTH ))
**[Month_End_Dax] - Date column.
** Rolling Period - Put -3, -6, -9 & -12.
Hi usually we will use today right why last date ?? Could you please reply
Last date will take last date in Data..to calculate mtd, qtd or P3M.....while today will take today's Date
@@indianparadisetrainer Why are we dividing in P3M (previous or past 3 months) dax measure by 3 , will it give Average 3 months sales?
I means, Are these following measure correct if i am not wrong
1. P3M
i. P3M (Previous or Past 3 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -3, Month))
ii. P3MAverage (Previous or Past 3 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -3, Month)) / 3
or
i. P3M (Previous or Past 3 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -3, Month))
ii. P3MAverage (Previous or Past 3 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -3, Month)) / 3
2. P6M
i. P6M (Previous or Past 6 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -6, Month))
ii. P6MAverage (Previous or Past 6 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -6, Month)) / 6
or
i. P3M (Previous or Past 6 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -6, Month))
ii. P3MAverage (Previous or Past 6 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -6, Month)) / 6
3. P9M
i. P9M (Previous or Past 9 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -9, Month))
ii. P9MAverage (Previous or Past 9 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -9, Month)) / 9
or
i. P9M (Previous or Past 9 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -9, Month))
ii. P9MAverage (Previous or Past 9 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -9, Month)) / 9
4. P12M
i. P12M (Previous or Past 12 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -12, Month))
ii. P12MAverage (Previous or Past 12 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Max(Calender[Date]), -12, Month)) / 12
or
i. P12M (Previous or Past 12 Months Sales) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -12, Month))
ii. P12MAverage (Previous or Past 12 Months Sales Average) = Calculate([TotalSales], DatesinPeriod( Calender[Date], Last(Calender[Date]), -12, Month)) / 12
Then for 6months average sales we divide with /6
1 quarter in year is 3 month thats why
..
Tq
Here why did you use /3
calculate the avg Monthly consumption....over the last three months
We can calculate in another way
@@indianparadisetrainer but in video you didn't mentioned the average so that I confused
Yes we have many ways
@@kishoregarlapati1971 please describe
why did u divide it by 3....so much confusion...also please provide dataset(for each video) for practice else no use to be honest..
Why /3 we are giving didnt understand....
To calculate average Monthly consumption...over last 3 months
@@indianparadisetrainer y didnt u add /6 /9 to otehrs