Forum Discussion
Only show data form yesterday, error message
hey Paritäa ,
don't understand what you are trying to do, the two DAX functions you used, filter and CalculateTables, return a table, and you are trying to assign a table to what I'm assuming is a measure... that's why you are getting that error message...
Can you be more specific about what you are trying to do, what measure are you trying to calculate?
Cheers, LQ
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.
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
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...
