Joining a Spreadsheet to a Semantic Model

Hi, BUC 

Consider using Power Query to merge spreadsheet data with semantic model data, rather than relying solely on direct relationships in the semantic model. Power Query allows for more flexible data manipulation, including merging tables based on common keys, and extending the resulting tables to include the required fields. 

If your semantic model is in Power BI, you can create calculated columns or measures to help aggregate transaction counts by date, even if a direct relationship between dates doesn't exist in the model. DAX is very powerful in creating dynamic aggregations based on relevant data
If you're using Power BI Desktop, a composite model might provide a solution. Composite models allow you to combine direct queries and import sources in the same report, which addresses some of the limitations of not being able to edit existing semantic model relationships.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.