I want to show items due in x amount of days

[Anonymous]

Hi

I have a bunch of deliverables on a spreadsheet and i want to use BI to be able to show when certain items are due based on a criteria, eg Show all items due in 7 days, 14 days, etc. HOw can this be done? 

Thanks in advance 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Try like the below:

create a slicer :

Then use the below measure:

Due in the next X days - n:

DueinthenextXdays = 
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Column2] >= TODAY ()
            && 'Table'[Column2]
                <= TODAY () + SELECTEDVALUE ( slicer[slicer] )
    )
)

Due in next Month - n:

DueinnextMonth = 
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    FILTER (
        ALL ( 'Table' ),
        IF (
            MONTH ( TODAY () ) < 12,
            MONTH ( 'Table'[Column2] )
                = MONTH ( TODAY () ) + 1
                && YEAR ( 'Table'[Column2] ) = YEAR ( TODAY () ),
            MONTH ( 'Table'[Column2] ) = 1
                && YEAR ( 'Table'[Column2] )
                    = YEAR ( TODAY () ) + 1
        )
    )
)

Overdue - n:

Overdue = CALCULATE(COUNT('Table'[Column1]),FILTER(ALL('Table'),'Table'[Column2]<TODAY()))

And if you want to view detail project ,change like below:

DueinthenextXdaysdetail = 
CALCULATE (
    MAX ( 'Table'[Column2] ),
    FILTER (
         ( 'Table' ),
        'Table'[Column2] >= TODAY ()
            && 'Table'[Column2]
                <= TODAY () + SELECTEDVALUE ( slicer[slicer] )
    )
)

Final you will get :

I project my pbix file  if you need.
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[parry2k]

@Anonymous 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

[Anonymous]

@parry2k  Thanks! 

So as an example, i have the table below (very simple)

Deliverable A	21/08/21
Deliverable B	09/09/21
Deliverable C	12/12/21
Deliverable D	01/01/22

So i want a simple dashboard widget to show -

Due in the next X days - n

Due in next Month - n

Overdue - n

But i need to use the current date, say 'within the next x days count how many items are due'.

Does this help?