How To Create a Date Table in Power Query | POWER BI | BI Tricks

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

КОМЕНТАРІ • 16

  • @ndimbereazenyui1634
    @ndimbereazenyui1634 Рік тому +2

    Rarely do I comment on videos ,but with this I could not skip this without doing so for you have save my soul. keep on with the good work

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

      Glad you liked my video

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

    Awesome! Finally someone who cuts to the chase immediately 😎 Thanks buddy!

  • @chasingdogs
    @chasingdogs Місяць тому

    Hi Ashish, What if we want to add some more details to the calendar, like, the Financial Year and Financial Quarter?

  • @Nani-et7gk
    @Nani-et7gk Рік тому

    Thankyou Ashish. I was searching for this question 😸

    • @bitricks
      @bitricks  Рік тому +1

      I am glad, it helped you😁

  • @newnami641
    @newnami641 5 місяців тому

    It’s very good video. Thank you so so so much. I have subscribed already ❤❤

    • @bitricks
      @bitricks  5 місяців тому

      Glad you liked it

  • @ahtishammasood1680
    @ahtishammasood1680 6 місяців тому

    Its really helpful

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

    Thank you 😌💖💖

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

      I am glad, you liked the video😇

  • @thulasinagaraj6715
    @thulasinagaraj6715 10 місяців тому

    Thanks

    • @bitricks
      @bitricks  10 місяців тому

      Glad you liked it

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

    I have a silly question. Why do you need to create a date table? Aside from time intelligence usage

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

      Let me clear your doubt.
      So when you are using time intelligence, Power BI will create a hidden Date table for each date column in your model.
      Now, if you have 5 date columns in your model, Power BI will create 5 hidden date tables inside your model.
      So, it is better to have a single custom date table in your model which is visible.