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