Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date difference between measure and table column

Hi,   I have a report in which I have created one measure (completed date) with following DAX formula:   Measure = IF(CALCULATE(COUNTROWS(SampleData),FILTER(SampleData,SampleData[Job Completion ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , change measure like and  change its data type to date

    Measure = IF(CALCULATE(COUNTROWS(SampleData),FILTER(SampleData,SampleData[Job Completion Date]=BLANK())) > 0, blank(), MAX(SampleData[Job Completion Date]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , change measure like and  change its data type to date

Measure = IF(CALCULATE(COUNTROWS(SampleData),FILTER(SampleData,SampleData[Job Completion Date]=BLANK())) > 0, blank(), MAX(SampleData[Job Completion Date]))