Show Days between TODAY and a future date - based on a filter?

[jlynch]

I am trying to show how much time is available for work per person between today and a floating deadline - CPA firm needs to know hours commited vs hours available to work.

I have added a Dates table, with a column for weekday (1/0) and created a relationship between the date column and the date in the table being used for the filter.  I created a measure in the table being used for the filter that has sum(dates[weekday]) as the formula and I only get the total of all dates, not the filtered sum of dates -

What am I doing wrong and what other information might help me solve this?

[AlexChen]

Hi,

I assume you have 2 tables: work and weekInfo. See screenshot below.

create relationships between these 2 tables:

create a column called “remainWorkingDays “ in “work” table:

remainWorkingDays = COUNTAX(Filter(weekInfo, weekInfo[date] >= TODAY() && weekInfo[date] <= 'work'[deadline] && weekInfo[weekday] = 1), weekInfo[weekday])

And you will see the result:

Best Regards

Alex

[CheenuSing]

@jlynch

Can you provide sample data and the output desired to come out with a solution.

Cheers

CheenuSing