Hi,
I have a report created from Excel file. I connect TableA and measures from Power Bi datasource I've created earlier. Then created one to many (single) relationship from calendar to TableA. Use measures in a matrix that has year-month hierarchy on rows. Everything is OK at the moment. TableA has dates almost every date for multiple years.
I connect TableB and its measures from same Power Bi dataset and create similar relationship like above. Relationship defaults to one-to-one (both) but I change it to one-to-many (single) relationship. This table has only one date per month and values only for year 2023. Right after I create relationship, matrix values before 2023 from TableA disappears and values for year 2023 changes to incorrect values.
For testing purposes I created new identical table TableC from connected TableA, created similar relationship, created new identical measure from this table and put it in the matrix and boom, values are correct with this new measure. This approach feels stupid because table and measures exist already in the connected data. And I'm concerned this causes troubles after publishing report and creating scheduled refresh. Sometimes scheduled refresh doesn't work with calculated columns or something.
Any ideas how to solve this problem without creating that extra table? Thanks.
