Get the total number of days per year in a Summarize Table

[Samkar78]

Hi,

I try to get the total numbers of days in a table created with a summarize function to have the correct average per day in a year.
For now I hard codded / 365 . but it is not accurate with Bisextile year (2020 ,2024...)

I have a fact table  V_ETP_TAXE_TRANSPORT_DETAIL, and a calendar table REF_CALENDRIER linked to it.

I only achieved to get the number of days linked to the detail of that table per Year (NU_ANNE) per company (CD_SOCIETE) and per area (LB_COMMUNAUTE)
or to get total number of days of my calendar table.

What function should I use to get 365 or 366 depending on the year on each row ?

[Samkar78 · Accepted solution]

I think I randomly found the solution using ALLEXCEPT

[v-yilong-msft]

Hi @Samkar78 ,

Congratulations on finding the answer you needed through your own efforts.

I researched your problem and found that the ALLEXCEPT function can indeed be used to solve your problem. Again, congratulations on solving your problem!

Best Regards

Yilong Zhou