Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Obeybe
Frequent Visitor

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

Obeybe_0-1606127030599.png

Can I achieve this with Power BI.

 

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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:

11.25.2.1.gif

When your data has updated, you need to click "Refresh", then it will change automaticlly:

11.25.2.2.gif

 

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

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

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:

11.25.2.1.gif

When your data has updated, you need to click "Refresh", then it will change automaticlly:

11.25.2.2.gif

 

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
Super User
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

vivran22
Community Champion
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?

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.