Time Intelligence in Power BI by Marco Russo

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

Комментарии • 24

  • @monicadurai150
    @monicadurai150 5 лет назад +8

    One of the best educational session I have come across in RUclips (or for that matter internet) for free. Thank you Marco and for the organiser who uploaded it!

  • @fleursj1301
    @fleursj1301 5 лет назад +3

    Thank you so much for posting this. It is very clear and informative.

  • @abeerattia4523
    @abeerattia4523 3 года назад

    Very excellent lecture , really it was great

  • @elliottharris4526
    @elliottharris4526 5 лет назад

    At 48m16s TOTALYTD is discussed. It shows that there is a year end argument that can be specified for Year End. Should there not also be a year start argument you can specify? This would make custom Financial Years a lot easier.

  • @silviab5579
    @silviab5579 6 лет назад +1

    Very good, excellently explained. Thank you very much!!!!

  • @andrefreitas1572
    @andrefreitas1572 3 года назад

    Great, very good explanation. Thank you very much, Marco Russo. I am thinking if I'd have to filter a KPI by two different dates within the same table. For instance, I'd like the Time Spent where Date.DateCreated = Today() + 7, which is the best time intelligence function(s) to approach that problem? Thanks!

  • @heraldfinch7010
    @heraldfinch7010 5 лет назад +1

    Very nice explanation !!

  • @DeepakChauhan-mn5jw
    @DeepakChauhan-mn5jw 6 лет назад +1

    Thumbs up to the speaker

  • @ks.karthick3356
    @ks.karthick3356 6 лет назад +2

    Super, I need to know for direct query mode this will work?

  • @bunty-memer
    @bunty-memer 2 года назад

    Where to download data used in this video from?

  • @suvadipkundu152
    @suvadipkundu152 6 лет назад

    Hi,
    Thanks a bunch for hosting (and sharing) this wonderful and very informative presentation.
    I have a query/suggestion though, @ 16:43, rather than using the sales order date as lower limit for the date table is it not safer to use the lowest of the (Sales and Purchase) dates as the lower limit and likewise for the max limit...using sales order date to baseline the table will exclude purchases made before the 1st Sale date. This will introduce errors at a later stage if we are trying to arrive at measures like cost of goods sold using the sale and the purchase tables

  • @danielansu9155
    @danielansu9155 3 года назад

    Hello, how can I calculate time over time difference for the same day or date

  • @fajnefajne4339
    @fajnefajne4339 4 года назад

    Thank you. Very nicely explained.

  • @venkateshthammisetty7845
    @venkateshthammisetty7845 4 года назад

    Hi Sir, is it possible to give year end date dynamically in TotalYTD DAX , so can u pls help me with this if there is a way.

  • @amal2503
    @amal2503 5 лет назад +1

    Excellent clarification !! Thanks a Lot

  • @1yyymmmddd
    @1yyymmmddd 6 лет назад +1

    Great explanation. Thanks!

  • @marilenadonofriotraining5589
    @marilenadonofriotraining5589 4 года назад +1

    Marco Russo, sei il migliore! ... anche Ferrari, certo :)

  • @meloduwine
    @meloduwine 6 лет назад

    Hi, can the date value within sales table be a calculated column using date function but in date format?

  • @waelkarkanawi8602
    @waelkarkanawi8602 5 лет назад

    Hallo at which database do you work?

  • @denxx6126
    @denxx6126 6 лет назад

    Am not so experienced in DAX and have the following requirement:
    It should be represented as follows on each date of sales ...
    ... YTD + MTD + the same for the previous year + deviation - all no problem ...
    BUT it should also be shown in addition to the selected date the entire previous year ...
    Is this possible with DAX?
    So you choose for example 15.03.2018 and then the following columns should be calculated:
    from 01.01.2018 to 15.03.2018 -> OK
    from 01.03.2018 to 15.03.2018 -> OK
    from 01.01.2017 to 15.03.2017 -> OK
    Deviation year to last year -> OK
    from 01.01.2017 to 31.12.2017 -> ???
    I thank you in advance.

  • @thedatalabs
    @thedatalabs 6 лет назад

    Very helpful.. Thanks

  • @cefuller12
    @cefuller12 4 года назад +2

    If while learning DAX you haven't laughed harder in frustration of using it, you're not doing it right.