Forum Discussion
problems with calculated column
thanks for the suggestion.
can i ask you for help in building the measure that takes into account the date filter? I can't figure out which is the right operation to do that takes all the elements into account.
thanks 🙂
Firstly it looks like you still have auto datetime enabled. You want to right click on the calandar table and mark it as a date table.
Are both of these table identical, but one is joined to the calandar table with creation date and the other with closing date?
ok, I corrected the type of the "date" field of the "_calendar" table with the type you indicated. Thanks!
exactly, they are both of these tables identical. the first one is linked to the "Date" field of the "_calendar" table with the "TKT_CreationDate - Date" field, while the second table is linked to the "Date" field of the "_calendar" table with the "TKT_ClosureDate - Date" field. I need this to find the number of tickets that have the creation date and the closing date within the same date filter. Thanks!
mark date table like this
Since you have the table dedicated to closed dates and that is filtered by date you can just count the number of rows
closed = countrows(Tickets_Datachiusura[TKT_ClosureDate - Date])You could do this with a singe table if you used the date table as a role playing dimension, something to think about
