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

Hi LQuedas 

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

LQuedas's avatar
LQuedas
Resolver II
3 years ago

Hey Paritäa 

let's try step by step 🙂

 

1) I created a new dataset with a column named TimeStampDate that I want to filter

2) I added a filter to the TimeStampDate Column to load all the rows except today's rows 

3) then I've edited the query with the advance editor

 

4) Finally, I Replaced the date #Date(2003,4,4) by the Year, Month and day of the UTCNow() function

Year - >  Date.Year(DateTimeZone.UtcNow())

Month - > Date.Month(DateTimeZone.UtcNow())

Day - > Date.Day(DateTimeZone.UtcNow())

 

This change will make the filter dynamic depending on the UTC now date.

 

Hope this now makes sense to you.

 

Cheers, LQ

 

 

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

    Expression.Error: The column 'TimestampUtc' of the table wasn't found.
    Details:
    TimestampUtc
    I got this error message before, but as you've seen at the screenshot there actually is a column named the exact name. I even copy pasted it to make sure...