Accounting For Missing Currency Rates w/DAX

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

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

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

    This is a fantastic scenario - the kind of thing you come across when you inherit a less than perfect data model. I've watched the later PQ solution but would want to try this way first until I was sure I could report on data quality issues in the source data. My scenario has sporadic capacity submissions by organisations so I will need to include a way to carry forward values only where provided within the 5 days of each date (so capacity can be tracked over time). Thanks!

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

    Thanks a lot. I suffered for two weeks ))

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

      Hi Bukovyna Medical Service, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
      Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA

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

    Thanks. It was very needed and interesting

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

      Hi Amdi, gald you liked the video.
      We have Power BI & DAX masterclass this July. If it interests you, click the link below:
      enterprisedna.co/power-bi-dax-master-class-july-2020-registration/

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

    Thanks!

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

      Hi Papa, glad you liked the video.
      We have Power BI & DAX masterclass this July. If it interests you, click the link below:
      enterprisedna.co/power-bi-dax-master-class-july-2020-registration/

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

      @@EnterpriseDNA GREAT! For us ,
      Thanks

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

    I have a situation where there are multiple currencies for the same vendor, and it is not giving the correct total / exchange rate. Is it possible to correct the dax for this situation?

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

      Hello Z Chase,
      thank you for posting your query onto our channel.
      Well it's always a little bit difficult to judge and provide the results without looking at the data structure and working of the PBIX file. Still we're providing few of the links of the videos available onto our Enterprise DNA RUclips channel pertaining to the currencies topic as well as how to fix incorrect totals in Power BI. We're also providing a link of one of the post from our Community Forum where one of our expert had created this post which serves as a helping post for all the forum members about to fix the totals in Power BI.
      For furthermore queries, we encourage you to please write back to us onto our Community Forum by providing the description of the problem that you're facing along with the PBIX file for the reference as well as by providing the mock-up file showcasing the results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
      Hoping you find this useful and meets your requirements that you've been looking for.
      Happy Learning!!!
      ruclips.net/video/i8WKBiTHqVI/видео.html
      ruclips.net/video/aNXvc4G3Q7I/видео.html
      ruclips.net/video/4dosxfNxR6M/видео.html
      ruclips.net/video/Daij-d6rOYU/видео.html
      ruclips.net/video/Rii_6qkLNh8/видео.html
      ruclips.net/video/44QUjA5NDwY/видео.html
      ruclips.net/video/PbkWkyKtAEw/видео.html
      blog.enterprisedna.co/multiple-currency-logic-in-power-bi-lookupvalue-example/
      blog.enterprisedna.co/fixing-incorrect-totals-using-dax-measures-in-power-bi/
      forum.enterprisedna.co/t/fix-incorrect-totals/8834
      forum.enterprisedna.co/

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

    if the reported date is earlier than the first currency date, how should i fix the dax?

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

      Hello Z Chase,
      thank you for posting your query onto our channel.
      Well if the reported date is earlier than the first currency date than it's recommended to load the currency data from that first reported data or you'll be required to consider the average currency value if it's permissible in your situation.
      For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
      Hoping you'll find this useful and meets your requirements that you've been looking for.
      Happy Learning!!!
      forum.enterprisedna.co/

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

      @@EnterpriseDNA noted. Average rate should be ok.