Forum Discussion

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago

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...
Need Help
codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago

I've created a sample pbix file. Where would you like for me to load it?  Thanks!!

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
9 years ago

codyraptor

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.

http://www.daxpatterns.com/time-patterns/