Explain the difference between Dates
filtering and Data Extraction​

Explain the difference between Dates
filtering and Data Extraction​

About the author
Claire

1 thought on “Explain the difference between Dates<br />filtering and Data Extraction​”

  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 (◠‿◕)

    Reply

Leave a Reply to Ariana Cancel reply