Forum Discussion

prekapRev's avatar
prekapRev
Frequent Visitor
6 years ago
Solved

Counts based on multiple dates in a table

I have a table with multiple date fields (Order Date, Ship Date, Delivery Date). I need to report on counts of sales, shipment and delivery for each month where either sale, shipment or delivery was ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    6 years ago

    Hi prekapRev  -

     

    Force your relationships between Cal_Date and Sales to be 1-to-many (Cal_Date on the 1 side) and it should work for you.

     

     

     

    Hope this helps

    David

prekapRev's avatar
prekapRev
Frequent Visitor
6 years ago

@dedelman_clng I want to attach my pbix file but I don't know how to attach any files here. I have done it exactly like you are showing in your solution but my result is different. not sure why.

dedelman_clng's avatar
dedelman_clng
Community Champion
6 years ago

Put it on a Dropbox, google drive or OneDrive and put the link into a post.