Max within row of pivoted dates

[kahnailee]

 Example data:

 Date            11/1 11/2 11/3 11/4

ProductA     10.45 10.45 10.81 10.45

ProductB      24.64 27.00 24.64 24.64

ProductC      50.61 50.61 50.61 55.00

Sorry for the crudity, but I basically want a custom measure that would show the MAX cost for each product across all available dates as the date span will change over time.

Thanks!

[Ashish_Mathur]

Hi,

Unpivot the dataset to convert it into a 3 column one.  In your visual, drag the Product to the row labels.  Write this measure

=MAX(Data[Value])

Hope this helps.

[kahnailee]

Thanks, but that won't work within my application as I need to keep the data pivoted to allow for the dates to remain within the columns. Any other suggestions? Perhaps filter?