Question

Explain the difference between Dates
filtering and Data Extraction​

Answer 1

Answer:

I need to create a measure that will subtract two times in seperate rows and provide me with the difference. I need to be able to filter my data using slicers and have the measure calculate on the filtered data. My data set is 60,000 rows and the measure I have to do this works, but not for my large data set. It will calculate endlessly without providing any results. I have used the measure in a small data set and had success (Ill post measure below). In excel I could subtract two cells in the same column easily but am having difficulty doing this in power bi. In my data set I have the UNIX time (column f_crtm) and a column labeled "Date" which has the following query to calculate: #datetime(1970,1,1,0,0,0)+#duration(0,-5,0,[f_crtm])

Basically, my end goal is to have a table visualization that I can filter and calculate the time differences between rows with a large data set.

HOPE HELPFUL TO YOU ALL (◠‿◕)