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

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

tex628  Oohh sorry, i just dubble check.. Both values are located in same dimension, although if i only use created date and max created date i only see blanc values. Any idea how this is possible?

  • tex628's avatar
    tex628
    Community Champion
    7 years ago

    I just went on vacation but i'll take a closer look later this week!

     

    /J

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi tex628 , 

     

    Hopefully you had a great holiday! Did you already had time to take a closer look? :) I still have no idea how to fix it!

  • tex628's avatar
    tex628
    Community Champion
    7 years ago

    Thank you! 

    The createdDate column, is it just a plain date column or is it a calculated column? 

    If its a calculated column, are you using the FORMAT() syntax? 


    Is it possible for you to send the pbix or is it confidential information?

    Br,
    J