Forum Discussion
Create Table for Resource Tracking
I'm trying to create a resource tracking table which would get populated from a single source where projects details are stored. For example the project details repository would have something like t...
hi Anonymous
For your case, you could try this simple way:
First, you should have a date table.
Second, then you could create a new calculated table
New table = FILTER(CROSSJOIN('Table','Date'),'Date'[Date]>='Table'[Start]&&'Date'[Date]<='Table'[End])Result:
and here is my sample pbix file, please try it
Regards,
Lin