![]() ![]() To do that, you need to create a new measure in your schedule data. ![]() If the date range (start and end of the project) coincides with the calendar dates we created, the cell should have 1, otherwise 0. We need to write a function that looks at the process dates and adds 0 or 1 based on the date range. The next thing is to add some values to these date columns we created. ![]() When you populate the columns with dates, your visual will fail, and you will see a message saying “Can’t display the visual” since there are no values associated with these dates that we created. If your calendar is created, you need to add the date variables to your columns of the matrix visual. You don’t have to add quarters, weeks, and/or days if you don’t need them in your schedule. Our dates will start from and go all the way to 2026. Here is the code we will use to create our calendar. Once your click “New Table”, PowerBI will let you write a DAX code starting with “Table =”. ![]() This will create a new empty table in your model. Click “New Table” in the top menu under “Calculations”. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |