Calculate Average of Last 3 Months vs Current Month in Power BI | DAX

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 ม.ค. 2025

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

  • @thebesttechnical3608
    @thebesttechnical3608 20 วันที่ผ่านมา

    Simple and easy to follow, thank you for this tutorial

    • @TheDataMakeover
      @TheDataMakeover  20 วันที่ผ่านมา

      @@thebesttechnical3608 thank you, I'm glad you found it helpful

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

    hey can u tell me hw did u got better at dax, can u tell the resourses u follwed to learn it ?

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

      @@vishalmane3139 I mostly learnt through scenarios because only when you are solving a problem you can push your brain to think which dax function would give you the desired output. Watch scenario based videos and check out dax workouts by enterprise dna.
      You can also browse through community forums to see what issues people are facing and try solving them yourself. This is something that I still do.
      All the best to you :)

  • @beingrishi6450
    @beingrishi6450 6 วันที่ผ่านมา

    Why divided by 3 given didnt clear this one related to avg 3 months measure.////

    • @TheDataMakeover
      @TheDataMakeover  6 วันที่ผ่านมา +1

      @@beingrishi6450 I am calculating average over a period of 3 months so I've hard coded the denominator as 3 but you can dynamically calculate the total number of months in your period and then use that variable as denominator