Search
-
Re: Get Last Modified date for PowerBI report from SQL
Final Scripts, if anyone else is doing PowerBI custom reports. This is for live, SQL, not DW. These are made to be joined together and give you combined IR/SR/MA reports. Combined as table WorkItems Calculated Column for last modified #if there is no lastmodified, then set to end date, if no end date, set to opendate. Last… -
Re: Get Last Modified date for PowerBI report from SQL
I had tried using the user and analyst comment log, but I could not get that to have the correct date, no matter what I attempted. I was using the relationship id below. System.WorkItem.TroubleTicketHasAnalystComment 835a64cd-7d41-10eb-e5e4-365ea2efc2ea AnalystComment AppliesToTroubleTicket For the Case statement, I was…