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?
10 Replies
Learn about the new windowing functions.
Introducing DAX Window Functions (Part 1) – pbidax (wordpress.com) INTRODUCING DAX WINDOW FUNCTIONS (PART 2) – pbidax (wordpress.com)
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?
