Hi, I created the following DAX calculated column, which I am using across different tables. =(YEAR(Today())-YEAR(DATEFIELD]))*12+MONTH(Today())-MONTH([DATEFIELD]) This field calculates how many months have elapsed from the date found in DATEFIELD until the time the model is processed. It works quite well, except for one little caveat: The DATE FIELD must exist within the table itself. But what if I want to relate to a date found at a date dimension table? Say that I only have a datekey in the table I want to hold my calculated field, and I want to refer to the date field found in the date dimension table. How would I go about it? I tried playing with the RELATED() function but I only got errors. Regards,P.

Neuro81 and ankitpatira Sorry for the trouble, but I managed to fix it in the end =(YEAR(Today())-YEAR(RELATED('Availability Calendar'[Date])))*12+MONTH(Today())-MONTH(RELATED('Availability Calendar'[Date])) The problem is that I got lost with the number of parenthesis (how lame!) So I deconstructed the formula and use a replace function to make it work. Wish I could delete this post altogether. Again sorry for wasting your time! :smileysad::smileymad:

DAX: relating a field from another table in a function

Forum Discussion

Related content

Related DAX Function

Related Functions

Iterator + related function

Filtercontext with date relation

RELATED function not working