how to make a daily report?

[sunjin122]

I am trying to make a Warehouse Daily (prior day & today) Reports. The Date column contains data from 2004 till now. Are there any smart ways to make the reports? I can only think of using the Date slicer to choose the certain day, howerver, it works not so well due to the large dataset. Plus, using the Date slicer is not straightforward and efficient for the manager who only requires data of prior day and current day. Hope some one can give me some smart advice, thanks ahead

[ankitpatira · Accepted solution]

@sunjin122 few ways to do it, depends on which one you prefer. you can do at data source level ie import only today's and previous day data. if not possible at data source level then create calculated column in power bi desktop that contains value Y or N. Y or if date range falls within current and previous day and N for otherwise. then use page level filter to filter out N from that calculated column.

[Eric_Zhang · Accepted solution]

@sunjin122

You can also filter the data in Power Query. One way

#"Filtered Rows" = Table.SelectRows(#"tableName", each [date] >= Date.From(DateTimeZone.UtcNow()+#duration(0,8,0,0)+#duration(-1,0,0,0)))

Date.From(DateTimeZone.UtcNow()+#duration(0,8,0,0)+#duration(-1,0,0,0)) returns the previous day. 8 indicates the timezone offset while -1 the previous day.

[ankitpatira · Accepted solution]

@sunjin122 few ways to do it, depends on which one you prefer. you can do at data source level ie import only today's and previous day data. if not possible at data source level then create calculated column in power bi desktop that contains value Y or N. Y or if date range falls within current and previous day and N for otherwise. then use page level filter to filter out N from that calculated column.