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.

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

lbendlin I'm puzzled as to why I don't get the same result as you. In my dataset, both tables are related to a plant dimension and a date dimension, and plant key is a calculated column in snapshot. Finally, equipment has over 1,7 million rows.

 

Could any of this thing affect the outcome? 

 

for example, for Dec 4, 2023, TC11BLO, you are getting 347 rows, which is the right amount. However, I get 0:

 

 

 

 

 

I'm seeing the filter is not taking into account the period of dates provided, only the specific day for that row, so it must find a perfect coincidence in plant and date to return anything.

 

Any idea? 

 

Thanks again.

  • 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.