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

[kollasv]

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.

[v-jianboli-msft · Accepted solution]

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.

[saravanan_p]

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.