Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

MAX measure not correct?

Hi - I've got a table with USDA prices in it, and I'm using MIN, MAX and STDEV to give me an idea of how a commodity is tracking. The table has 4 different commodities in it, and MAX works for 3 of them, but not the 4th and I cannot figure out why. It's the same table being analyzed. 

 

The measure is : 

Maximum beef & pork = MAX('Combined beef & pork trim'[Weighted average])
 
Any suggestions? 
 
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I found out the issue - there were duplicate dates in the table. Apparently that confuses the DAX measure. 

     

     

2 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    The provided information base is quite small to reconstruct or undesteand the usecase
    Can you provide sample data and expected result. At least screenshots would be a good start.

    Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I found out the issue - there were duplicate dates in the table. Apparently that confuses the DAX measure.