Forum Discussion

Ronning's avatar
Ronning
Frequent Visitor
3 years ago

Problem with measure

 Hi 
I have touble to create Measure1 & Measure2 in the picture below. Hope someone have any ideas Thanks // 

Need Help

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    you'll need your date field to be converted to an actual date format first - then you can use:  

     

    Measure = CALCULATE(FIRSTDATE('Table'[Date]),'Table'[Profession]="Analyst",ALLEXCEPT('Table','Table'[Patient]))
     
    Measure 2 = var datecheck = CALCULATE(FIRSTDATE('Table'[Date]),'Table'[Profession]="Analyst",ALLEXCEPT('Table','Table'[Patient]))
    return
    if(isblank(CALCULATE(COUNT('Table'[Date]),'Table'[Date]<datecheck,ALLEXCEPT('Table','Table'[Patient]))),0,CALCULATE(COUNT('Table'[Date]),'Table'[Date]<datecheck,ALLEXCEPT('Table','Table'[Patient])))
     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    • Ronning's avatar
      Ronning
      Frequent Visitor
      3 years ago

      Thanks for youre help, i still have an issue.  I get an error (duplicate date as been given to FIRSTDATE).
      Then i tried to make a datetable an connected it to the date column. But i only get the lowest date that exists for every row