Calculation Of Due in Next 30 days

[Anonymous]

I am trying to calculate list of documents which are Due in Next 30 days (Including Today).

Tried multiple ways however not getting the correct numbers. Can you please correct me ?

The condition is either [Due In Date] OR [Forecast Submission Date] should be in next 30 days and I am trying the below DAX.

Documents due in next 30 days =
CALCULATE (
    [Total Documents],
    FILTER ( 'Merged Table', 'Merged Table'[Actual In] = BLANK () ),
    OR (
        DATESBETWEEN ('Merged Table'[Due In Date], TODAY (), TODAY () + 30 ),
        DATESBETWEEN ('Merged Table'[Forecast Submission Date], TODAY (), TODAY () + 30 )
    )

[Ahmedx · Accepted solution]

pls try this

Documents due in next 30 days =
VAR _toDay = TODAY ()
VAR _End = _toDay+30
RETURN
CALCULATE (
    [Total Documents],
    ALL('Merged Table'),
     'Merged Table'[Actual In] = BLANK () ,
      OR (
        'Merged Table'[Due In Date]>=,_toDay&& () 'Merged Table'[Due In Date]<=_End,
        'Merged Table'[Forecast Submission Date]>=,_toDay&& () 'Merged Table'[Forecast Submission Date]<=_End
    )
-------OR-----
Documents due in next 30 days =
VAR _toDay = TODAY ()
VAR _End = _toDay+30
RETURN
CALCULATE (
    [Total Documents],
     'Merged Table'[Actual In] = BLANK () ,
      OR (
        'Merged Table'[Due In Date]>=,_toDay&& () 'Merged Table'[Due In Date]<=_End,
        'Merged Table'[Forecast Submission Date]>=,_toDay&& () 'Merged Table'[Forecast Submission Date]<=_End
    )

[Anonymous]

Hi @Ahmedx ,

Your second solution is right and is working well.

However, there is another requirement now in the same DAX is below-

Latest of (Forecast Date > today +30 and Forecast date <= today+30) and (Due in Date > today+30 and Due in date <= today+30)

We need to consider the Latest of either Forecast Date OR DueIn Date.

[Ahmedx]

I don’t understand, but this is a new question, create a new topic and explain in detail what you need and expect the result

[Ahmedx]

you mean that today it will be + 30
this

[philouduv]

Could you shre the data model so we can adapt the formula, because it works on my fake table ?
If you want to Count you could use this : 

due 30 = CALCULATE(COUNTROWS(Table911),FILTER(Table911,

DATEDIFF(TODAY() ,Table911[due date].[Date],DAY) <= 30 || DATEDIFF(TODAY() ,Table911[forecast date].[Date],DAY) <= 30))

[philouduv]

Hello @Anonymous ,
I tried to create a calculated column in a table and putted Yes if need to be process and No if not, then you can filter it on visual 
Formula:

due 30 = IF(DATEDIFF(TODAY() ,Table911[due date].[Date],DAY) <= 30 || DATEDIFF(TODAY() ,Table911[forecast date].[Date],DAY) <= 30, "Yes", "No")

NB: the formula  will also consider past date, if you want to avoid that, filter on date >= from Today


Best regards

[Anonymous]

Appreciate your effort however, this doesn't work.

Need to show how many are due in next 30 days i.e. Count Of Documents