Forum Discussion

Guustc's avatar
Guustc
Helper I
10 years ago
Solved

Totalling Ledger NAV

I think the title is not clear at all, but it is difficult to give my problem 'a name'.   I have the following table (an example, of course there is more data in each row)    GL Account Number - ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Guustc

     

    According to your example, we need to update the formula of Kostensoort column as below.

     

     

    Kostensoort =
VAR Name_Index =
    IF (
        ISBLANK ( Grootboekrekening[Naam] ),
        CALCULATE (
            MIN ( Grootboekrekening[Index] ),
            FILTER (
                Grootboekrekening,
                Grootboekrekening[Index] > EARLIER ( Grootboekrekening[Index] )
                    && Grootboekrekening[Naam] <> BLANK ()
            )
        ),
        Grootboekrekening[Index]
    )
RETURN
    (
        LOOKUPVALUE ( Grootboekrekening[Naam], Grootboekrekening[Index], Name_Index )
)

     

     

    Regards,

Guustc's avatar
Guustc
Helper I
10 years ago

v-sihou-msft thanks for your reply!

I wanted to implement the second solution, but I can not get it to work. I made an index colum and used the formula you gave me, but it does exactly the opposite. I tried to change the if_false value to if_true, but then i get an DAX error.

 

 

You can see the example above.

I tried many things, but i do not know what i am doing from. Do you have an idea?

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

Guustc

 

According to your example, we need to update the formula of Kostensoort column as below.

 

 

Kostensoort =
VAR Name_Index =
    IF (
        ISBLANK ( Grootboekrekening[Naam] ),
        CALCULATE (
            MIN ( Grootboekrekening[Index] ),
            FILTER (
                Grootboekrekening,
                Grootboekrekening[Index] > EARLIER ( Grootboekrekening[Index] )
                    && Grootboekrekening[Naam] <> BLANK ()
            )
        ),
        Grootboekrekening[Index]
    )
RETURN
    (
        LOOKUPVALUE ( Grootboekrekening[Naam], Grootboekrekening[Index], Name_Index )
)

 

 

Regards,

  • Guustc's avatar
    Guustc
    Helper I
    10 years ago

    v-sihou-msft that works fine! Enormous thanks! Almost got a headache out of this problem, this really helps me go forward :)