Forum Discussion
Personal project need help to get started
I accomplished the foundations of my projects in a day today after I looked into the data schema and implementing it in power bi. So I ended up with three tables, and I believe it made it easier to compare income vs expenses and set up some measures. It was pretty cool when I got the first one, and the next ones were easier to create once I got the hang of it. I'm pleased with the progress from today but I know there is much more I need to learn and understand.
It was a struggle to get anything to work before posting here on the forum (it was frustrating), so I'm truly appreciative of the help offered by the posters above to lead me in the right direction.
Super Userdatsright , You are going the right way. But prefer a start schema and date table,
refer
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/