Forum Discussion

medlalami's avatar
medlalami
Helper I
5 years ago
Solved

Compare entries between two data

Hi all, I have a table named DimDate that contains Dates in different format. And another table named Problems, that have two fields (created on and closed on), that I linked with the field Date, av...
Need Help
  • medlalami's avatar
    medlalami
    5 years ago

    Solved but creating a mesure:

    Closure = CALCULATE(COUNTROWS(Problems),USERELATIONSHIP(Problems[Closed On], DimDate[Date]))
medlalami's avatar
medlalami
Helper I
5 years ago

I have a problem with the relations. The values of opened problems are correct but not the case for the closed values.