First of all, I want to greet you all a Happy, Peaceful and Blessed New Year 2020!
If you are one of those who regularly visit my website, allow me to have this opportunity to thank you for your time and I hope you find something useful and educational in my website that you can use in your day-to-day work.
May this year fill your life with happiness, good health, and prosperity! I wish you to look forward to this year, 2020, with confidence and courage, giving wings to your dreams!
Live your life to the fullest possibilities.
Have a blessed day! God bless you all.
Hi there! I hope all is well with you.
If you happen to be one of the Power BI champions out there, I would appreciate it much if you could give me some support in getting the result I am aiming.
Basically, I have this spreadsheet showing the resources weekly of each employee, similar to the one shown in Figure 01.
Next, I decided to create a Power BI dashboard using the data in the “Resource spreadsheet” Excel document.
Then I came up with this one:
Assuming today is Week 48, Tuesday (Day 2), I’ve added a “Card” visualisation to show “Project01” for employee Name01 (assuming I have selected “Name01” on my “Slicer” filter for the “Employee Name”).
Then what I would like to happen the next time I open my Power BI, say on Monday next week (Week 49), the “Card” opposite each “Week Day Name” will update automatically and give me the values of Week 49 as shown below (assuming I have selected “Name01” on my “Slicer” filter for the “Employee Name”).
And my Power BI dashboard should look like in Figure 04.
Similarly, for Employee Name02, the Power BI dashboard should look like in Figure 05.
The help I would like to ask is whether you could please help me in writing the DAX formula or method which will return a value based on the current day of the week and the corresponding week number.
Once again, I really appreciate it much if you could help me in solving this little puzzle of mine.
I’m looking forward to the support.