Forum Discussion

surajde's avatar
surajde
Helper I
3 years ago

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?    
Need Help
Show and Tell
Tips and Tricks
surajde's avatar
surajde
Helper I
3 years ago

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_NUMTICKET_OPENEDSEVERITYACTIVITY_TYPETICKET_STATE1ACTIVITY_TIMESTART_TIMESTOP_TIME
3097037485/2/2022 13:214Customer LogQueued5/2/2022 13:21NULL5/2/2022 13:21
3097037485/2/2022 13:214Initial CreationQueued5/2/2022 13:215/2/2022 13:215/4/2022 13:57
3097037485/2/2022 13:214Customer LogQueued5/4/2022 13:575/4/2022 13:575/6/2022 15:17
3097037485/2/2022 13:214Customer LogQueued5/6/2022 15:175/6/2022 15:17NULL
  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    why does the start_time need to be null for the first entry? Do you need a measure or is a calculated column enough?

    • surajde's avatar
      surajde
      Helper I
      3 years ago

      Hi lbendlin, 

      A calulted column is enough. this way I will be able to count the actual differed time. 

       

       

      • surajde's avatar
        surajde
        Helper I
        3 years ago

        lbendlin Sorry for chasing you. But got any luck?