Solved: Row calculation - Page 2

edgarjb-68 · ‎09-18-2019

How to calculate rows on a table in Power BI? I want to create a column "started" as below, for each row of this column I need the result like this excel formula: =IF(AND(A3=A2;B3-B2<1);"No";"yes")

part	install date	started
PAU-0101	26/03/2019 05:17	yes
PAU-0101	07/04/2019 18:56	No
PAU-0101	07/04/2019 19:56	yes
PAU-0102	26/03/2019 05:17	yes
PAU-0102	07/04/2019 18:56	No
PAU-0102	07/04/2019 19:56	yes

Anonymous · ‎09-23-2019

Hi ,
Can you try to change the datediff to minutes and change the less than condition.
Thanks.

View solution in original post

edgarjb-68 · ‎09-23-2019

JUST PERFECT!!!

started = VAR v_LagPart = CALCULATE( MAX( Data[part] ), FILTER( Data, Data[part] = EARLIER( Data[part] ) && Data[installdate] < EARLIER( Data[installdate] ) ) ) VAR v_LagDate = CALCULATE( MAX( Data[installdate] ), FILTER( Data, Data[part] = EARLIER( Data[part] ) && Data[installdate] < EARLIER( Data[installdate] ) ) ) RETURN IF( Data[part] = v_LagPart && ( DATEDIFF( v_LagDate, Data[installdate], MINUTE ) < 1440 ), "No", "Yes" )

View solution in original post

Row calculation

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly