Forum Discussion
Paritäa
3 years agoFrequent Visitor
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...
LQuedas
Resolver II
3 years agohey 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
Paritäa
3 years agoFrequent Visitor
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.