I’ve been struggling to create these calculated columns in Power BI. Columns F,G,H contain a formula which calculates the time a job has been “frozen”. When the same job has been froze/unfroze they are grouped together as in the example. The formula checks to see if the word “freeze” is contained in the cell and then makes sure “Job 1” is the same in both A2 & A3. It then looks to D2 to see if it is < than I2, if it is than it gets the working days from (D3 - D2).
Has anyone encountered a problem like this? My initial thought was to try and manipulate the data in power query so all the “req ID’s” are one line? Any help is appreciated
Hi @kurzashane, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!