Forum Discussion

Tamila's avatar
Tamila
Frequent Visitor
3 years ago
Solved

Problem with datas

Hello to all. Would greatly appreciate your help with the following matter. I have two tables:  1. Dates - 1.01.2016 to today (i.e. March 11, 2023) 2. Employees - list of employees with hiring and...
Need Help
  • Tamila's avatar
    Tamila
    3 years ago

    Thank you for the suggestion, tried it, same problem(

Tamila's avatar
Tamila
Frequent Visitor
3 years ago

Thank you for the suggestion, tried it, same problem(

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Tamila  can you share the measure you wrote?

  • Tamila's avatar
    Tamila
    Frequent Visitor
    3 years ago
    Max data = CALCULATE(MAX('0. Дата'[Date]),ALLEXCEPT('0. Дата','0. Дата'[Date]))
    • Tamila's avatar
      Tamila
      Frequent Visitor
      3 years ago

      Sorry, my mistake, here is the correct formula 

      Max data = CALCULATE(MAX('0. Дата'[Date]),ALLEXCEPT('3. Employee','3. Employee'[Name]))
       
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Hi,

        Share the download link of the PBI file.  If data is confidential, anonymise the data first.  Please also show the expected result.