Forum Discussion
Solved
Count Rows Falling between two dates ( from disconnected table )
Hi, I am having two disconnected tables ( Task and Ticket). On Task Table I need to count tickets (from the Ticket table) that fall between the task created date and Created +90 date. In Excel,...
I still don't see an issue here
You need to display
'Table 1'[Created] and'Table 1'[Created +90] in the viz for the DAX to evaluate in the filter context. Without having that axis present, the expression will not evaluate.But if you do want to have that one displayed without bringing'Table 1'[Created] and'Table 1'[Created +90]then you need an index column and do this with a new measure
I think this is what the exact challenge is; to make this measure work without including task number or date (lowest level) into the viz.
I am using powerbi dataset, so I can't even make this work using the calculated column.