Need help with my code - incremental calculated column DAX

Hi everyone,

I am a newbie in powerbi and struggling with a quite complex task.

I need to get a measure of "chain sessions" per user that I want to use for conditional formatting later and here is how it should work.

I need to get in Powerbi these 3 columns or calculations:

• column A that measures if the session duration (per user) is >= 45 minutes 
• column B that measures if the difference between this session and previous session (per user) is < 5 days.
• column C contains the logic on how I want to get my chain session measured.

I am struggling understanding how to get the same thing done into powerbi, not sure if I should choose a calculated column or a measure since all of this measure should also consider the UserID in that table, should be calculated on the previous row for that specific UserID.

This could be the whole table, please note that I added first 3 columns only to get a general understanding, it does not work with calculations I made before.
Every day I get the sessions for each UserID.

Can someone help me with that?

Thank you,

Hi, 

I posted my first post last week and worked on it, now I need some help trying to fix my code which is almost working.

I found this post previously https://community.powerbi.com/t5/Desktop/How-can-I-write-a-formula-for-incremental-addition-similar-to/m-p/931124 and applied  v-diye-msft  's answer to my code.

It's a little bit different since I have to conditions to satisfy in order to get the incremental calc.

I now have column A and B which contain the conditions I need to verify (1 is true and 0 is false).

Then I need my calculation to do this:

if (A = 1, if (B = 1, incremental calc, 1), 0)

Saw in that solution I needed to create 2 columns to do so. Here they are:

As you can see, my Column 3, the one with the incremental calculation, is not working but I can't fix the error. 

This is the code for Column:

Column = 

CALCULATE (

    COUNTROWS ( 'Table' ),

    FILTER (

        'Table',

        'Table'[Data] <= EARLIER ( 'Table'[Data] )

            && 'Table'[A] = 1 && 'Table'[B] = 1

    ), FILTER('Table','Table'[Name] = EARLIER('Table'[Name])))

Column 3 = 

VAR c = 'Table'[Data]

VAR pre =

    CALCULATE (

        MAX ( 'Table'[Data] ),

        FILTER ( 'Table', 'Table'[Data] < c && 'Table'[A] = 0 && 'Table'[B] = 0 ),

        FILTER('Table','Table'[Name] = EARLIER('Table'[Name])

    ))

RETURN

    IF (

        'Table'[A] = 1, if( 'Table'[B] = 1,

        CALCULATE (

            COUNTROWS ( 'Table' ),

            FILTER('Table', 

                    'Table'[Name] = EARLIER('Table'[Name])),

            FILTER (

                'Table',

                'Table'[Data] <= EARLIER ( 'Table'[Data] )

                   && 'Table'[B] <> 0 && 'Table'[A] <> 0

            - CALCULATE ( MAX ( 'Table'[Column] ), FILTER ( 'Table', 'Table'[Data] = pre && 'Table'[B] <> 0 && 'Table'[A] <> 0) ))), 1), 0)

maddaelle , can you provide logic, what are you trying to achieve

The information you have provided is not making the problem clear to me. Can you please explain with an example.
For a faster solutions refer https://www.youtube.com/watch?v=UrFuZ2uHjdY
Appreciate your Kudos.