Forum Discussion

Paritäa's avatar
Paritäa
Frequent Visitor
3 years ago

Only show data form yesterday, error message

I've been trying to filter my data in order to only show data from yesterday. I tried it in Power Query where I import the dataset and I've tried it in DAX. It never works. I always receive the erro...
Need Help
Paritäa's avatar
Paritäa
Frequent Visitor
3 years ago

I don't really know what I have to do. I did some research and found these option by either creating a measure or new table to filter the data. 

This data will be automated as new data is measured every day. But I only need to visualize the data from yesterday. I'm just trying to add a function so that the  original dataset is reduced to measurements from yesterday. 

LQuedas's avatar
LQuedas
Resolver II
3 years ago

Hey Paritäa ,

 

you can use the Power Query Editor to filter the dataset, as example, I created a small table with today and yesterday rows:

 

then I've edited the query and added the date filter:

with this filter the today data is removed from the table.

 

Hope this works for you.

 

Cheers, LQ

  • Paritäa's avatar
    Paritäa
    Frequent Visitor
    3 years ago

    I get the following error:

    Expression.Error: The field 'date' of the record wasn't found.

    A friend of mine said I should try with daytime but the same error appears...

    • LQuedas's avatar
      LQuedas
      Resolver II
      3 years ago

      Hey Paritäa ,

       

      the field 'date' only exists in my example, you need to adapt the code to your situation, I don't know the names of your dataset's columns name.

       

       

       

      Cheers, LQ

      • Paritäa's avatar
        Paritäa
        Frequent Visitor
        3 years ago

        Hi LQuedas 

        I did change them. But is it correct that < #date, does not refer to the column, right?