Forum Discussion
Date calculation between 3 tables
I have a 'Dispatch' table that has a distinct count of dispatches. It is connected to a 'Vendor' table with a distinct set of vendors. The 'Vendor' table is connected to a 'Vendor Program' table wh...
Can you please upload a sample PBIX file somewhere? If you dont want to share actual data please provide dummy data.
Frank
I've created a sample pbix file. Where would you like for me to load it? Thanks!!
Do you have a dedicated date table? Most date logic/time intelligence requires a dedicated date table with no missing dates in order for the dax to work appropriately.
See here for more information.
Hi codyraptor,
Please provide us some sample data and expected result, so that we can make further analysis. You could upload the sample file to onedrive and share it.
Regards,
Charlie Liao
