Handling Multiple Dates in Power BI With DAX [2022 Update] 

you saved my life thanks!!

Hi @rosswilliams1058, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

Hi @samhall100, we’re glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

Hi DreamBasel, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming tutorials and announcements. Cheers!

Hello Abhishek, You don't have to physically use the "Order Date" and "Ship Date" fields in your reporting visualizations. By creating a virtual relationship using this function between "Order Date (from Sales table) and Date (from Date table)" and "Ship Date (from Sales table) and Date (from Date table)", Date field from date table will handle both of the fields from Sales table accordingly. And by following that approach, it'll still work provided you use date field from date tables in your charts and the measures which are created which evaluates the results accordingly. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, 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! If you haven't yet, you can subscribe to our RU-vid channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hello @vikashparihar8366, If you want to analyse the metrics by 10 different dates then you'll have to write 10 different measures, in that case, there're no shortcuts available in that regard. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our RU-vid channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

@@EnterpriseDNA Actually, i have 2 dates only. Suppose in your example. If you want to calculate eg shipping cost by shipping date. But use date from other data set (not shipping date data set). Would you create another dax ?

I think that the best way to solve this problem is having multiple dCalendar Tables in your model, i use this approach whenever its is necessary to use drillthroughs to detail the data...(use the correspond dCalendar)

Thanks @@DanielTavares29 I expected that to be the answer, I was hoping there would be a nicer way to get around the problem as my data has a lot of dates. A previous reporting tool I have used had a drill through function that when applied to a calculation it would activate all filters held within the measure, It would be really handy in PBI

Hello @onyenetochinedu3371, We request you to please write the entire description of the problem so that the scenario is understandable and assistance can be provided in a better and efficient manner. We're not sure how you're referring about it can be implemented with the "COUNTROWS()" but in our scenario's, we're able to implement it so you can try it in your reporting requirements as well. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our RU-vid channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

@@EnterpriseDNA Thanks for your response Below is the issue I encountered and how I was able to work around it 1. I discovered that If you have an existing active relationship within the same table , the ‘Userelationship’ works as a subset of the existing relationship 2. Fix: I had to make sure that the existing active relationship is unchecked (inactive) so that the ‘userelationship’ formula can work independently I don’t know if there is a better way to work around it Thank you

Hi @ajaypatil4083, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers! Sign up here: app.enterprisedna.co/sign-up

Hi Ali, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. The append operation doesn't overwrite anything and it just adds one table below the another which contains same characteristics of information. And while you want historical data in a as-is form and update/refresh the API related data on a daily basis, in that case, you can implement incremental refresh technique in your model. Below are few of the links provided of the documentation from Microsoft's website pertaining to that topic for your reference purposes. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, 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! You can subscribe to our RU-vid channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

@@EnterpriseDNA thanks very much for the comprehensive response. It was very helpful!