Is there a way for me to calculate the days between two periods?

[Syndicate_Admin]

Good morning

I have to make a report to keep track of the signings and I need to put the days that people are on vacation.

For example, I have this data:

I need that in a table I get the dates of the period "FromDate" to the "ToDate", that is to say the following:

Is there a way for the dates between "FromDate" to "ToDate" to be broken down? Or that when I detect that the current day corresponds to a date of this period I dientify it and leave it as Vacation?

Thank you!

[Jihwan_Kim]

Hi,

If your expected result is to create a calcualted table, please check the link down below.

https://jihwankimcscp.wixsite.com/supplychainflow/post/create-a-calculated-table-that-contains-activ...

Today morning, I wrote a short blog post that creates a calculated table by using GENERATE DAX function.

The structure of the origin table is the same (showing a start date and end date for each ID).

I hope this helps.

Thank you.

[Syndicate_Admin]

@Syndicate_Admin

Hello!

It has worked, but if to the formula we use we need to add another variable, how would the formula be?

In other words, this is the formula that you have created:

Where _startdate =

MIN('Presence Control Exemptions'[FromDate])

Where _enddate =

Max ('Presence Control Exemptions'[ToDate])

Where _calendar =

SELECTCOLUMNS(CALENDAR(_startdate, _enddate), "@Date", [date])

Where _addemployee =

GENERATE(

_calendar,

FILTER(

'Presence Control Exemptions',

'Presence Control Exemptions'[FromDate] >= [@Date]

&& OR ('Presence Control Exemptions'[ToDate] >= [@Date], 'Presence Control Exemptions'[ToDate]= BLANK () )

)

)

RETURN

SUMMARIZE(_addemployee, [@Date], 'Presence Control Exemptions'[UserID])

But I need to add this other variable:

Where _exemption =

GENERATE(

_calendar,

FILTER(

'Presence Control Exemptions',

'Presence Control Exemptions'[FromDate] >= [@Date]

&& OR ('Presence Control Exemptions'[ToDate] >= [@Date], 'Presence Control Exemptions'[ToDate]= BLANK () )

)

)

But I don't know how to put it in the SUMARIZE at the end.... Can you help me?

So as one these two SUMMARIZE:

SUMMARIZE(_exemption, [@Date], 'Presence Control Exemptions'[ExTypeId])

SUMMARIZE(_addemployee, [@Date], 'Presence Control Exemptions'[UserID])

Thanks a lot!

[Jihwan_Kim]

Hi,

Thank you for your feedback, but sorry that I am not sure whether I understood your last question correctly.

Could you please try something like below?

SUMMARIZE(_exemption, [@Date], 'Presence Control Exemptions'[ExTypeId], 'Presence Control Exemptions'[UserID])