Forum Discussion
Display Weekly Total based on a report that is generated daily
I have report which is generated daily to CSV and then imported into SQL every day. The report has no date timestamp, so when the CSV is imported into SQL, it adds a datestamp column. I want to s...
parry2k
Super User
Super Userhatchda create a date table in your model and you should have a column in this called weekday, there are many posts on how to add one, here is one of my post, and then add a measure
Server Count on Sunday =
CALCULATE ( COUNTROWS ( Table ), KEEPFILTERS ( DateTable[Weekday] = "Sunday" ) )
On the bar chart, use date on the x-axis from the date table and above measure, it should work.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡