Forum Discussion

Saap's avatar
Saap
Resolver III
4 years ago
Solved

Difference to last month using disconnected time table

Hi all, In my fact table I have 3 columns: [Employee], [ContractStart] and [ContractStop]. I also have a disconnected time table. Using dates from disconnected time table and below measure I c...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Right click on your Date table and choose "Mark as date table". Time intelligence functions like PREVIOUSMONTH need a proper date table.

    Nothing else needs changing, you don't need a relationship from Date to Employees and the measure you have works fine.

johnt75's avatar
johnt75
Super User
4 years ago

Right click on your Date table and choose "Mark as date table". Time intelligence functions like PREVIOUSMONTH need a proper date table.

Nothing else needs changing, you don't need a relationship from Date to Employees and the measure you have works fine.

  • Saap's avatar
    Saap
    Resolver III
    4 years ago

    Hijohnt75 

    Thanks, that works perfectly.
    I didn't think that marking date table as a date table would solve this problem.
    In my other reports I didn't mark the date table and PREVIOUSMONTH worked anyway so I thought the problem lies somewhere else.