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],        ...
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.

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