Forum Discussion

sekinod's avatar
sekinod
Icon for Helper II rankHelper II
5 years ago
Solved

Month End Value and Current Date Value

I have the following data which contains the target value for each month-end. So, what I want is when selecting a particular date on the slicer, All the months' end value for each month up to ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can't add the slicer date easily, so here is a second measure you can add to the visual to show that.

     

    MaxDate in Target =
    VAR seldate =
        MIN ( Dates[Date] )
    VAR eomdate =
        CALCULATE (
            MAX ( Target[Date] ),
            ALL ( Dates )
        )
    RETURN
        IF (
            seldate < eomdate,
            seldate,
            eomdate
        )
     
    Regards,
    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

I did use your pbix but it did not have any visuals, so I couldn't see how you were selecting the date.  Here is my file.

Regards,

Pat

sekinod's avatar
sekinod
Icon for Helper II rankHelper II
5 years ago

Dear mahoneypat 

Values getting for measure is correct, but the last column date also shown as monthend date it should be selected date.

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi sekinod,

    In fact, current power bi not support to create dynamic calculated columns based on filter/slicer. They are works on different data level and you can't use the child level filter to affect their parent.

    Notice: the data level of power bi.
    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view wiht virtual tables (measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng