Show planned leave or taken Leave based on Current Date

[heygowtam]

Hi,

I Have table (Leave Table ) that shows employer leave details in Dates FROM  and TO, for this i need to build Measure

If worker is planning to go for leave for 5 Days ===> Planned Leave = 5, 

if worker is on leave its been 3 days and coming back after 2 days ======> Taken Leave = 3 and Planned Leave =2, 

If Worker has finished is leave then =======> Taken Leave = 5 

So, I need 2 columns in Table planned Leave and Taken Leave basde on Current Date. @Greg_Deckler ,  @PaulDBrown 

[heygowtam]

@amitchandak This is a Sample Data, Duration in Hours and Applied Leave is in Days  Thanks for your Reply

[amitchandak]

@heygowtam , There can be a few ways, like

[Applied Leave] - Duration/24

or

[Applied Leave] - Duration/8

roundup can be used

[Applied Leave] - roundup(Duration/24,0)

or

[Applied Leave] - networkdays([from],[to],1)

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[heygowtam]

@amitchandak Based on the above table, I need a Measure where i can use for Dashboard 

I want Applied Leaves to be in Two Different Columns As Planned Leave or Taken Leave 

one day = 7.6 hours 

[v-easonf-msft]

Hi, @heygowtam 

Not very clear. Can you explain bit more?
Sample data and expected result will make it easier for us to understand and solve your problem.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@heygowtam , Need to know the columns that are there in the table
Can you please share sample data and sample output in table format? Or a sample pbix after removing sensitive data.