Calling Power BI Champion, I need your expert advise, please.

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.

Figure 01: Resource spreadsheet in Excel

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:

Figure 02: Resource spreadsheet Power BI Dashboard

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”).

Figure 03: Employee Name01 Week 49 Work Load

And my Power BI dashboard should look like in Figure 04.

Figure 04: Employee Name01 Week 49 Work Load Power BI dashboard

Similarly, for Employee Name02, the Power BI dashboard should look like in Figure 05.

Figure 05: Employee Name02 Week 49 Work Load Power BI dashboard

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.

Cheers.

Revit Dynamo PowerBI Workflow Video Recording – Part 2

Hello there. It’s me again, Allan Cantos. I trust you are well.

You have seen in my previous post the video recording that I did when I was preparing for my presentation for the 2018 BiLT Conference. I hope you don’t mind the accent (hahaha) but rather look at what you can get from that video recording.

If you missed watching that first part, I highly recommend that you go back to that video first before continuing watching this part 2 to get a better understanding of what happened in the first part.

Here is the link for the first part:

Revit Dynamo PowerBI Workflow Video Recording – Part 1

And here is the Part 2 recording:

As a correction, the video recording mentioned about using the latest Dynamo version installed in your machine if you have 2 or 3 versions installed. Actually, I have not tested this in Dynamo 2.x versions yet so it may or may not work. I suggest using Dynamo 1.x versions.

If you need a hard copy of this tutorial, you can download it from the links provided below. I hope you’ll support me in funding the expenses of running this website. It’s my personal online library and it will be yours too.

Using PayPal:

Revit-Dynamo-Power BI Guide ebook (PayPal)

Using Credit/Debit Card:

Revit-Dynamo-Power BI Guide ebook (Credit/Debit Card)

I hope you find this video tutorial helpful. Please leave your comment below if you have any questions.

Have a great day!

Cheers.

Revit Dynamo PowerBI Workflow Video Recording – Part 1

I found my practice recording of the first part of my BILT Asia 2018 presentation. For the whole documentation about this presentation, you can grab a copy from the link provided further down below.

I would like to thank you, in advance, for your support. My website (allscan12.com) will keep on running for as long as there is someone like you who would be willing to spend a small amount to support me in funding my online library. It will be your online library too. Your support is very much appreciated.

For some of you who haven’t get a copy yet, here are the two links for you to choose from, where you can purchase a downloadable PDF copy, depending on your payment option.

Using PayPal:

Revit-Dynamo-Power BI Guide ebook (PayPal)

Using Credit/Debit Card:

Revit-Dynamo-Power BI Guide ebook (Credit/Debit Card)

Have a great day and watch out for part 2 of my practice video recording.

Cheers.