Forum Discussion
Count Days Between Two Dates in Same Column
I am building reports in powerbi using an established data model where the security in place prevents the ability to add columns; thus I must develop a measure to calculate the number of days between...
hi Anonymous
Try to plot a table visual with UniqueIdentifier and a measure like:daysbetween =VAR _date = MAX(TableName[EventDate])VAR _datepre =MAXX(FILTER(ALL(TableName[EventDate]),TableName[EventDate]<_date),TableName[EventDate])RETURNDATEDIFF(_datepre, _date, DAY)
FreemanZ
Super User
Super Userhi Anonymous
doable. would need the info of other columns to locate date rows. could you enrich your data sample?
Other columns, as a minimum, would include:
Unique Identifier Field (each record/row)
Eventdate (referenced originally)
Title Field
Event Summary Field
Responsible Department Field
- FreemanZ
hi Anonymous
Try to plot a table visual with UniqueIdentifier and a measure like:daysbetween =VAR _date = MAX(TableName[EventDate])VAR _datepre =MAXX(FILTER(ALL(TableName[EventDate]),TableName[EventDate]<_date),TableName[EventDate])RETURNDATEDIFF(_datepre, _date, DAY)Thank you! I will try this!
- FreemanZ
hi Anonymous
and the criteria to pick dates for duration calculation?
To include on a visual whether table, combo graph (bar (event) line (days between events)