return table results

[Durbslaw]

Hi,

How do I get a datediff from all rows instead of min, max or sum.

workdays without holidays =

CALCULATE(

    COUNTROWS(PERIOD),

    DatesBetween(

        'Period'[Datekey],

        min('Leave Management'[DateFrom]),

        max('Leave Management'[DateTo])),

    Filter(

        Period,

        'Period'[ISWorkDay] = 1 &&

        'Period'[IsPublicHoliday] = FALSE

     ),

    ALLSELECTED('Leave Management')

)

[v-yalanwu-msft · Accepted solution]

Hi, @Durbslaw ;

I'm sorry that the information you provided is too little for me to understand. Can you give a simple example or a simple document and what you want to output? In order to understand your logic.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Durbslaw]

Aplogies @v-yalanwu-msft , I was trying to get to a summarized result. I managed to get something like..Day1LeaveCatergory = countx(Summarize('Leave Management',"Leave Day Catergory",FILTER('Leave Management','Leave Management'[DateDiff] = "1-Day")),[DateDiff])

but I get a scalar value error