Accenture Interview Question | How to Calculate Past 3 Months, P6M Sales | Time Intelligence DAX

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ธ.ค. 2024

ความคิดเห็น • 19

  • @jyothirmaitalks
    @jyothirmaitalks 3 หลายเดือนก่อน

    Sir,can we use date add function for last 3 months sales?

  • @VikasKumar-fk4kp
    @VikasKumar-fk4kp 3 หลายเดือนก่อน

    @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.

  • @pawaniredde5574
    @pawaniredde5574 4 หลายเดือนก่อน +1

    Hi usually we will use today right why last date ?? Could you please reply

    • @indianparadisetrainer
      @indianparadisetrainer  4 หลายเดือนก่อน +1

      Last date will take last date in Data..to calculate mtd, qtd or P3M.....while today will take today's Date

    • @PowerBiWithVivek
      @PowerBiWithVivek 5 วันที่ผ่านมา

      @@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

  • @LaxmiChinta-q1z
    @LaxmiChinta-q1z 3 หลายเดือนก่อน

    Then for 6months average sales we divide with /6

    • @ThePhoenix-q1o
      @ThePhoenix-q1o 3 หลายเดือนก่อน +1

      1 quarter in year is 3 month thats why
      ..

    • @LaxmiChinta-q1z
      @LaxmiChinta-q1z 3 หลายเดือนก่อน

      Tq

  • @its_mrpanchal
    @its_mrpanchal 4 หลายเดือนก่อน +1

    Here why did you use /3

    • @indianparadisetrainer
      @indianparadisetrainer  4 หลายเดือนก่อน +2

      calculate the avg Monthly consumption....over the last three months

    • @kishoregarlapati1971
      @kishoregarlapati1971 4 หลายเดือนก่อน +1

      We can calculate in another way

    • @its_mrpanchal
      @its_mrpanchal 4 หลายเดือนก่อน +1

      @@indianparadisetrainer but in video you didn't mentioned the average so that I confused

    • @indianparadisetrainer
      @indianparadisetrainer  4 หลายเดือนก่อน

      Yes we have many ways

    • @its_mrpanchal
      @its_mrpanchal 4 หลายเดือนก่อน

      @@kishoregarlapati1971 please describe

  • @amitthorat-s8y
    @amitthorat-s8y 4 หลายเดือนก่อน

    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..

  • @beingrishi6450
    @beingrishi6450 4 หลายเดือนก่อน +1

    Why /3 we are giving didnt understand....

    • @indianparadisetrainer
      @indianparadisetrainer  4 หลายเดือนก่อน

      To calculate average Monthly consumption...over last 3 months

    • @vishalmane3139
      @vishalmane3139 4 หลายเดือนก่อน

      @@indianparadisetrainer y didnt u add /6 /9 to otehrs