Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
@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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |