Forum Discussion

vrawert's avatar
vrawert
Regular Visitor
6 years ago

Count days between 2 dates in different columns for multiple entries

Hi all, I’m new to dax formulas (Power Pivot – BI – Query) and I’m trying to do some calculation in a dataset that I need to analyze.   My data consist of 2 columns of dates (start date of a disco...
rainer1's avatar
rainer1
Resolver III
6 years ago

Hi vrawert,

 

it's not possible to filter with an inactive relation, so if you want filter between start and end you need two slicers one for the start date and the other for the end. 

 

For the calculation for the day between the two dates you can use

 

Diff = DATEDIFF(MIN(Tabelle1[Start Date];Tabelle1[End Date]);MAX(Tabelle1[Start Date];Tabelle1[End Date]);DAY)

 

 
 

 

I build up a small sample report for you based on your data.

 

 

I hope this will help you...

 

regards

 

rainer1