Update report with weekly information

[Obeybe]

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.

[Anonymous · Accepted solution]

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

[amitchandak]

@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

[vivran22]

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?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter