Forum Discussion

Durbslaw's avatar
Durbslaw
Helper I
4 years ago
Solved

return table results

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')
)
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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's avatar
      Durbslaw
      Helper I
      4 years ago

      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