Explain the difference between Dates
filtering and Data Extraction​

Question

Explain the difference between Dates
filtering and Data Extraction​

in progress 0
Claire 3 months 2021-07-06T16:11:35+00:00 1 Answers 0 views 0

Answers ( )

    0
    2021-07-06T16:12:48+00:00

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

Leave an answer

Browse

9:3-3+1x3-4:2 = ? ( )