Forum Discussion
Update report with weekly information
Hi,
I'm new in Power Bi and I want to update my newly created report with info from a sharepoint list every week.
Now I have to modify the date manually in my report but I would like te do this automaticlly.
My report as 4 columns
BookingDate, Event_Location, Registred_Status and Measure_By_Desks
Can I achieve this with Power BI.
Hi Obeybe ,
According to my understand, you want to keep data always current week,right?
You could add a WeekNum column then use the following formula:
WeekNum = WEEKNUM ( 'Table5'[Date], 2 )Measure = IF ( MAX ( 'Table5'[WeekNum] ) = WEEKNUM ( TODAY (), 2 ), 1, 0 )Then apply the measure to the filter pane:
When your data has updated, you need to click "Refresh", then it will change automaticlly:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin
3 Replies
- vivran22
Community Champion
Hey Obeybe !
What do you mean by when you say modify date manually? Can you please share more details, and if possible with a sample data along with expected output?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter - amitchandak
Super User
Obeybe , Have column like these in you date table
Start Week = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
End Week = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)use week type as slicer and filter that on this week
Also refer :https://www.youtube.com/watch?v=hfn05preQYA
Hi Obeybe ,
According to my understand, you want to keep data always current week,right?
You could add a WeekNum column then use the following formula:
WeekNum = WEEKNUM ( 'Table5'[Date], 2 )Measure = IF ( MAX ( 'Table5'[WeekNum] ) = WEEKNUM ( TODAY (), 2 ), 1, 0 )Then apply the measure to the filter pane:
When your data has updated, you need to click "Refresh", then it will change automaticlly:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin
