Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX QUERY FOR FILL DOWN

Hi Professionals..!!   Need help in understanding the dax for getting the last column data as measure, basically it is a fill down in dax.
FILL DOWN IN DAX
  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Your pbix file has a page-filter.

    Please try the below and check the attached file.

     

    Mydesire = 
VAR currentrows =
    MAX ( Mydata[Rows] )
VAR currentdate =
    MAX ( Mydata[Date] )
VAR startdate =
    MINX (
        FILTER ( ALLSELECTED( Mydata ), Mydata[Rows] = currentrows && Mydata[NewMC] <> BLANK () ),
        Mydata[Date]
    )
VAR previousdate =
    MAXX (
        FILTER (
            ALLSELECTED ( Mydata ),
            Mydata[Rows] = currentrows
                && Mydata[Date] <= currentdate
                && Mydata[NewMC] <> BLANK ()
        ),
        Mydata[Date]
    )
VAR previousvalue =
    MAXX (
        FILTER ( ALLSELECTED ( Mydata ), Mydata[Rows] = currentrows && Mydata[Date] = previousdate ),
        Mydata[NewMC]
    )
RETURN
    IF (
        HASONEVALUE ( Mydata[Rows] ),
        IF ( MAX ( Mydata[Date] ) = startdate, SUM ( Mydata[NewMC] ), previousvalue )
    )