Filtering a table off of Date Table

Question

HI All,&nbsp;I am trying to show previous historical data where have 2 requirements for showing it previously based off of the date; Lead Initiated and Lead Confirmed. Both of these fields are dates which are linked to my date table.&nbsp; I want the table to filter out all jobs in which the lead confrimed date is before the date in the column while also filtering out the jobs in which the Lead Initiated date is greater than the date in the column.&nbsp; This should give me a slice of the jobs which given any date where in the pipeline for Lead Initated to lead confirmed. After the table is filtered I would then like to do calculations on it such as Count, Average, Percentile etc.&nbsp; Any help with this would be appreciated.&nbsp;&nbsp;Best,Ele

parry2k · Answer

Elevation123&nbsp;it will be easier you paste some sample data with the expected output.&nbsp;Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

elevation123 · Answer

How do I attach the CSV? It is saying the file type is not supported

parry2k · Answer

Elevation123&nbsp;you can share using onedrive/google drive

elevation123 · Answer

Example File&nbsp; Here it is

Forum Discussion

Filtering a table off of Date Table

4 Replies

Related content

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Filtering Table report

How to search specific word in table filter Calculations

Lakehouse Table Generate Create Table