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!
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
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/
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/
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?
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/
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/
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!
Thanks a lot. I suffered for two weeks ))
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
Thanks. It was very needed and interesting
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/
Thanks!
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/
@@EnterpriseDNA GREAT! For us ,
Thanks
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?
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/
if the reported date is earlier than the first currency date, how should i fix the dax?
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/
@@EnterpriseDNA noted. Average rate should be ok.