Forum Discussion
Data Prep in Power Bi for Operational Dashboard
Hi Super Users, I having some dillema with this data. If I have the following data, reported of the counts on a weekly basis (Fridays of each week): Total Active Inactive Performance V...
parry2k
Super User
Super Userketay for the date table, take a look at the playlist on my YT channel:
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Thanks for the reply parry2k. I will adpot the date table and make use of it.
Do you have any recommendation towards displaying the total active and total inactive per category and per item? If I use distinct count seems to only counts the rows of distinct asset, but could not count the value on each.