Switching Relationships Dynamically in DAX

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • It is important to have multiple relations between your transactions(facts) and your lookup(dimensions) and you can use the relations as per the circumstance for e.g., using your invoice date vs. payment date vs. order date. Different calculations are based on different dates, how would you change them without manually touching the entities?
    In this video, we will see how you can switch within these relationships dynamically by using DAX.
    This is very powerful and it can be used for a number of Finance use cases.
  • НаукаНаука

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

  • @ashishmohan4707
    @ashishmohan4707 3 года назад +1

    Hi Krishna
    very useful video and very practical need everyone for every project ......very big thanks to share with us.
    If it can possible can you plzz provide us excel data file which you used.
    Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

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

      The data I used is from adventure works sample database from microsoft..

    • @ashishmohan4707
      @ashishmohan4707 3 года назад +1

      @@dataexplained7305 ok ok i have that data thanks 👍👍👍👍
      Your explanation is very clear and very informative