Forum Discussion
PowerBI same column calculation
Hi, I need help for performing calculation within same column on PowerBI like I did it in MS Excel. =IF(A2<>A1, "NULL", F2). How to put this formula in DAX?
Hi,
It is easier to solve this in the Query Editor. If you are interested, then share data in a format the can be pasted in an MS Excel file and show the expected result.
Hi Ashish_Mathur , lbendlin
Here is the data you need. I need calculaiton in last two columns. Start time and Stop time.
Start time :
=IF(A2<>A1, "NULL", F2).
Stop Time :
=IF(A3=A2, F3, "NULL")
TICKET_NUM TICKET_OPENED SEVERITY ACTIVITY_TYPE TICKET_STATE1 ACTIVITY_TIME START_TIME STOP_TIME 309703748 5/2/2022 13:21 4 Customer Log Queued 5/2/2022 13:21 NULL 5/2/2022 13:21 309703748 5/2/2022 13:21 4 Initial Creation Queued 5/2/2022 13:21 5/2/2022 13:21 5/4/2022 13:57 309703748 5/2/2022 13:21 4 Customer Log Queued 5/4/2022 13:57 5/4/2022 13:57 5/6/2022 15:17 309703748 5/2/2022 13:21 4 Customer Log Queued 5/6/2022 15:17 5/6/2022 15:17 NULL any luck on above mentioned query, please?
why does the start_time need to be null for the first entry? Do you need a measure or is a calculated column enough?
Hi,
Would you be OK with a Query Editor solution?
