Forum Discussion
how do i get last week sale for same period when I don't have the dates column
Hi there, I have data in this format: One column has the year. The second column has the period (12 periods in a year, but they are not the same as months, as they start on different dates). The...
Are you using Power BI? You'd need a date dimension table that maps the days in a year to the periods. If you do a search for "power bi date table" there should be quite a few examples. If your data is coming out of an accounting system, it'll often have a date table you can use somewhere in the database.
yes, i am using powerbi,
do i need to create dates in data table even though i don't have data according dates?