Forum Discussion
YTD for multiple measures in matrix
Microsoft EmployeeHi Archana,
The TOTALYTD iterates over the dates. So we need feed it with dates rather than years. Please try it like below. The [CreatedDate] should be from the same table with columns of Matrix.
YTDPaid = TOTALYTD(count('Table1'[Paid]),[CreatedDate])
YTDActive = TOTALYTD(count('Table1'[Active]),[CreatedDate])
Best Regards,
Dale
Hello,
thanks for your reply.
But with above calculation - I need to write 4+ calculations - one for paid, one active and so on for each status and I will end up placing it in rows - which gives results like this:
Expectation is this:
Each status which has different calculation i.e. different columns in DB view - Paid,Active,Contacted,Quoted -- set to 1 or 0 and am summing it up in report level) - there's no "status" column as such in DB (should I make one? and bring in data in a different way altogether?)
I want to achieve 1 calc for all the status which changes based on the column/metric (status) in rows