Forum Discussion

kollasv's avatar
kollasv
Icon for Helper I rankHelper I
4 years ago
Solved

Need a measure or calculated column for a particular data based on a date

Hi Team,

I need to filter timesheet not submitted resources list based on a selection in the slicer, everything is good but if i select a week which is in february, the list is showing, but in that "Resources not submitted list" the resources who were not joined in the Feb( Eg: I and M, their joing date is in march)  also showing like they were not submitted the timesheets in Feb, before joining date how they can submitt the timesheets, 

I need to remove those names from the "Resources not submittes list" table whose joing date is less than the selected date (in slicer yellow colour arrow)

is there any calculated measure/column possible like that...... please help me dear profeessionls... it is really need for me.

Need Help

2 Replies

  • saravanan_p's avatar
    saravanan_p
    Icon for Resolver III rankResolver III
    4 years ago

    Hi,
    It is good if we receive sample file , else you may try using below steps:

    create a measure :

    c1= var select_Date= selected value(MonthTimesheetWeek) Return

    if(resource joining date < select_Date,1,0)
    Use this measure page level or table filter and select to1. You should be seeing only users flagged with 1.
    If the solution is correct, kindly mark as solution.

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi kollasv ,

     

    Approve with saravanan_p ,

    Based on your description, I have created a simple sample like this:

    Note: there is no relationship between the two tables.

    Then create a measure:

     

    Measure = IF(MAX('Table'[Date])<= SELECTEDVALUE('Date'[Date]),1,0)

     

    apply it to the visual:

    Then use the filter:

    Final output:

    If the result is not what you want, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.