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 are made using creation date, but facing challenge for inactive relationship month wise (Month column is used from Date Dim Table), i am using similar calculation for non cumulative values which is working fine. if you anyone can help
3 Replies
- rajendraongole1
Super User
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 !!
