Number of Nights between two dates

[gauravnarchal]

Hello All

Is there a way to calculate the Number of Nights between two dates?

If so, please suggest a way to do it as a calculated column & through the measure.

Many thanks

Gaurav

[Anonymous · Accepted solution]

Hi  @gauravnarchal ,

I create some data:

Here are the steps you can follow：

1. Create calculated column.

day_number = DATEDIFF('Table'[Start date],'Table'[End date],DAY)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnalystPower]

"Days Between = DATESBETWEEN ( 'Table' [Dates], 'Table' [Start Date], 'Table [End Date] ) This will return a single number for the number of days between the two dates."

https://community.powerbi.com/t5/Desktop/calculate-number-of-days-between-2-dates/m-p/51213#:~:text=....

[Fowmy]

@gauravnarchal 

What is the night definition you would use? I mean the time frame