Forum Discussion
Month Wise Cumulative Data for Inactive Relationship
hi team, i am facing challenge finding Month Wise Cumulative Data for Inactive Relationship as mentioned in the table below, the calculation are working fine for open and total tickets as they ar...
rajendraongole1
Super User
Super UserHi 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 !!
After writing the above calculation the whole data is through same value from January to December