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
tex628's avatar
tex628
Community Champion
7 years ago

What dataformat is [CreatedDate]?

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

    • Tahreem24's avatar
      Tahreem24
      Super User
      7 years ago

      Hi Anonymous ,

       

      I tried with Both the Date/Time and Date data type and it gives me output. If possible so can please put your created date column in seperate pbix file and send the file here with masking of your data.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

         Tahreem24 I know, but i just the datatypes and this seems to be right. (See prt screens query editor and pbi attached). For both I selected same "createddate"  column.