Forum Discussion

IAM's avatar
IAM
Icon for Helper III rankHelper III
1 year ago
Solved

My brain doesn't function, help! Count overdues in a month.

Hi all,   My brain stopped working, can you help me figure this out?   I have a tabel with a start and finsih date per month (So per row a First day and a Last day of the month) and I want to add...
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    IAM 

    Calculated Column

    OpenAndOverdueCount = 
    VAR StartDate = Report[First day]
    VAR EndDate = Report[Last day]

    RETURN
    COUNTROWS(
    FILTER(
    IW38,
    IW38[Date created] <= EndDate &&
    (ISBLANK(IW38[Date finished]) || IW38[Date finished] >= StartDate) &&
    IW38[Duedate] < EndDate
    )
    )

    💌If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi IAM ,

 

You can try the following dax expression.

OpenAndOverdueTickets = 
VAR StartDate = Report[First day]
VAR EndDate = Report[Last day]
RETURN
CALCULATE(
    COUNTROWS(IW38),
    IW38[Date created] <= EndDate,
    IW38[Duedate] <= EndDate,
    IW38[Date finished] > EndDate || ISBLANK(IW38[Date finished])
)

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.