Forum Discussion

MarceloSaez's avatar
MarceloSaez
Icon for Helper I rankHelper I
5 years ago

Calculated column varying result for each row depending on dates and item within the same table

Hello guys! hope you're doing all well. Here is a tricky one (at least for my modest knowledge): I have a set of items (oil-producing wells - Well), and each one of them has an oil production histo...
Need Help
MarceloSaez's avatar
MarceloSaez
Icon for Helper I rankHelper I
5 years ago

amitchandak, in the following link you can find:

  • Desired output table: a sample table of the desired output (one distinct value of DNA for each row). For instance, I obtained the values for Sep-2020 by deleting the Oct-2020 data from the source data, so MAX(date[Date]) refers to Sep-2020.
  • Source file: the source original data file (excel file),
  • the pbix (you can find this file in my original post).

There is no sensitive data as all the data contained in these files is not real.

Thank you so much for your interest.

Regards,