Forum Discussion

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
5 years ago
Solved

Datediff using months

Hi hopefully a quick query for a Guru.   i created a calculated column for an age in months as follows: No of months old = -DATEDIFF(TODAY(), '01_Calendar'[Date], MONTH)   It works out the valu...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Pmorg73 

     

    Sorry for not being able to reply you in time due to busy Monday.

    If you use a calendar table date column in your visual, you can easily modify your measure.

    Like this:

    Measure =
MAXX (
    FILTER ( 'Table', [job summary] = SELECTEDVALUE ( 'Table'[job summary] ) ),
    RELATED ( 'Table 2'[Date] )
)

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
5 years ago

This is my data table (its quite large and I dont want to share it as its business info)

 

 

this is the section of the model

 

 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Pmorg73 

 

Because the specific context is not clear,the result may be some unexpected circumstances. Anyway, I am glad you can modify it yourself.

If you have other questions, please feel free to ask me.

 

Best Regards

Janey Guo