Forum Discussion

leandro_vegacr's avatar
leandro_vegacr
Icon for Helper I rankHelper I
2 years ago
Solved

Calculated column is not returning the desired value using Calculate

Hello all.   I have two tables, equipment and snapshot. equipment has all assets, snapshot report on some issues with assets. snapshot has a date column called run_date, where the snapshot of the s...
  • lbendlin's avatar
    lbendlin
    2 years ago

    DATEADD applies to the entire column.  To shift individual dates you use EDATE.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

leandro_vegacr's avatar
leandro_vegacr
Icon for Helper I rankHelper I
2 years ago

I understand full data may be required, but I'm restricted to share it. I ended up creating a measure, based on your ideas and the measure is working fine for my purposes, so this is good enough. Again, realy thnakful for the effort.