Max Value at First Day of Month from Multiple Fact Tables

[MarcelLandsky]

Hi, I'm stuck on a case where there are multiple fact tables are present. I'm trying to build below table by max rank on the beginning of month from trx and calculate measures from the camp table. The data has the last and current ranks in same rows. I've created two seperate date tables for each fact but struggling to get the stages. I was also thinking preparing a new table on db taking snapshots and introducing to the model but not sure if it's the feasible way.    

	sumamount	sumprices
high
mid
low

trx

uid	last_rank	last_rank_date	new_rank	new_rank_date	campid
1	low	03.01.2022	mid	05.01.2022	11
1	mid	05.01.2022	high	20.01.2022	11
2	low	25.01.2022	high	15.03.2022	12

camp

uid	campid	camp_date	amount	price
1	11	02.01.2022	...
1	12	24.01.2022
2	12	24.01.2022

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.