Forum Discussion
Need help finding the right function and syntax in PBI report
I have two tables (date, and issues table). The Date table has sequential dates for reference from 2016 to 2020 in order. My issues table has a list of work incidents, namely with a "closed date" and...
Hi,
Your question is not clear. Show both tables and the expected result.
Hi....
Below is the pic of the 2nd (issues) table. Showing the resolveddatewithnulllogic column. There's another column named opened date. I'm wanting to compare against the "calendar_date" rows in the date table (shown in first post) and say for each row in the task table, for between the opened date and resolveddatewithnulllogic was it open for each calendar date by day and if so mark a 1 operator, if not a 0 operator. Does that clear my question up? The goal is to see what issues were open for each calendar_date day in the date table to look at open tickets (issues).