Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Max value date

We are trying to create a measure which shows us the created date. To determine this we use the max function (or maxx), but we will not see values. Our formula is the following:  max created date = ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

tex628  Dataformat is date/time. Tried to change it to date as well, but that also doesn't give any output. 

tex628's avatar
tex628
Community Champion
7 years ago

Well thats strange.. Because you're not wrong, MAX should indeed work in this situation. 

If you take a new plain table. Add only the date column and your measure, do you get the same result? 

/J

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    tex628  What do you mean? Do you mean same as i already provided in the prt screen in the original post? There you see created date and the outcome of the measure? Or do you mean something else?

    • tex628's avatar
      tex628
      Community Champion
      7 years ago

      Considering that Feb 20 appears twice it looks like there are more dimensions in the table from your screenshot. 

      If you are able to share the file it would make this alot easier. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        tex628 Aahh, I think you're right!!! If I only select createdDate and max createdDate i don't get any values!! Do you have any idea how to fix that? I would like to now whether my created date is more than 6 months ago. Therefore i would like to compare created day with today. Measure would be easy if i have created day