Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

MINX with multiple conditions

hi, I have a table that i am trying to get the date from the previous row. To make it work properly I created an index column. This index column is responsible to classify the information, based on ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ，

     

    Try this calculated column:

     

    DATEFORMPREVIOUS = 
VAR __cur_id = 'Table'[ID]
VAR __cur_event = 'Table'[EVENT]
VAR __cur_index = 'Table'[INDEX]
VAR __result =
    CALCULATE (
        MIN ( 'Table'[DATE1] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[ID] = __cur_id
                && 'Table'[EVENT] = __cur_event
                && 'Table'[INDEX] = __cur_index - 1
        )
    )
RETURN
    __result

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,


Please check the below picture and the attached pbix file.

 

 

OFFSET function (DAX) - DAX | Microsoft Learn

Expected result CC = 
MAXX (
    OFFSET (
        -1,
        'Table',
        ORDERBY ( 'Table'[INDEX], ASC ),
        ,
        PARTITIONBY ( 'Table'[EVENT] ),
        MATCHBY ( 'Table'[DATE1], 'Table'[EVENT], 'Table'[ID], 'Table'[INDEX] )
    ),
    'Table'[DATE1]
)

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you for your help!

I'm trying to apply this solution into the real case, but it seems to not work because the "relation" parameter from offset has duplicated lines. How can I send you the file back with a table that is more like the real case?

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

    Hi,

    Thank you for your message, and you can share the link of the file (Onedrive, Dropbox, Googledrive, others...).

    Thank you.