Month Wise Cumulative Data for Inactive Relationship

Hi Jayesh - calculate the monthly sales using the inactive relationship and give a relationship between dates and sales tables common columns.

use the below measure for monthly sales to get the values from inactive relationships.

MonthlySales =
CALCULATE(
SUM('Sales'[SalesAmount]),
USERELATIONSHIP('Sales'[SalesDate], 'Date'[Date])
)

create another measure for cumulative measure:

CumulativeSales =
VAR LastVisibleDate = MAX('Date'[Date])
RETURN
CALCULATE(
[MonthlySales],
FILTER(
ALL('Date'),
'Date'[Date] <= LastVisibleDate
)
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!