Forum Discussion

cbailey92's avatar
cbailey92
New Member
5 years ago

TOTALMTD and USERELATIONSHIP

Hi All,   I am trying to calculate a MTD value based on a date column from my 'Quotes' table that is different to the date column that has an active relationship with my calendar.   I think I nee...
month-to-date
time-intelligence
TOTALMTD
USERELATIONSHIP
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
5 years ago

Hi cbailey92 

The logic of your measure appears correct to me.

It is simultaneously applying a MTD filter on your 'calendar' table, and activating the relationship with the [Quote Won Date] column.

 

I tested your measure in a small sample data model and it gave the expected result.

 

Could you post either a link to a shareable PBIX or some some sample data and the result you are getting?

 

Regards,

Owen