How to find if your product/event falls inside of a promotion period with Power Query

Поділитися
Вставка
  • Опубліковано 24 лис 2024

КОМЕНТАРІ • 16

  • @drewbbc7074
    @drewbbc7074 2 роки тому +1

    A range lookup join executed directly within an addcol statement - very clean & elegant.

  • @johnj108
    @johnj108 3 роки тому +2

    So much learnings in a single video.
    Thank you 🙏

  • @alessandroverde1885
    @alessandroverde1885 Рік тому

    Excellent job!!!

  • @kennethstephani692
    @kennethstephani692 2 роки тому

    Great video!

  • @cosladacity1
    @cosladacity1 3 роки тому +1

    i love your content!! so smart and efficient

  • @malchicken
    @malchicken 3 роки тому +3

    Excellent video. I think this builds well into a video explaining recursion using…Aggregate or Generate I think maybe there was a video on that before. I’d be interested to see this double each technique across different scenarios maybe, to drive home the point. Or potential pitfalls and work-arounds, like if you need to make a list to do a function and then make it back into a table to then perform the each on? The relation to DAX Earlier is appreciated, it helps me understand that concept better as well. 2 for 1.

  • @odel_leal
    @odel_leal 2 роки тому

    Súper useful. Thank you

  • @qasimkhan-ft3tu
    @qasimkhan-ft3tu 3 роки тому +2

    Your videos are always exceptional Sir.

  • @larmondoflairallen4705
    @larmondoflairallen4705 2 роки тому +1

    Will you be posting more videos? I haven't seen anything new for several months. I really enjoy and get a lot out of your content, and I would love to see more!

    • @ExceedLearning
      @ExceedLearning  2 роки тому +1

      Hi Larmondo! Thanks for reaching out! We will start posting new videos soon! In the last couple of months, we were occupied with several projects, one of which is our new tool for financial forensics we launched last week. exceed.hr/en/products/benedict-accounting-analysis-and-controlling-system/
      Now that it is out, we can continue with videos :)

  • @eslamsaeed3
    @eslamsaeed3 2 роки тому

    Amazing video, and excellent presentation, I tried a lot to reach how look up value in date ranges as per date list criteria, this anabatic and fantastic from you,
    Thanks Bro

  • @ajieapen
    @ajieapen 2 роки тому

    Super awesome..!! Exactly what I have been looking for... Could you share the workbook, please?

  • @qasimjan5258
    @qasimjan5258 2 роки тому

    It has been a long time you didn't post a video Sir. Seems very busy.

  • @SamehRSameh
    @SamehRSameh 2 роки тому

    We Need explain M language all functions such as
    list. Family
    Date. family
    etc ....

  • @alexandermilland6674
    @alexandermilland6674 Рік тому

    This seems awfully slow, we are talking a row a second at most?
    Comparing roughly 150.000 lines of campaigns to roughly 10.000.000 lines of fact sales. (Comparing on a datetimefield and a productID)
    The EARLIER function in dax is way faster for me but requires me to store a datetime field on the fact salestable. Anyone else have a work around?