Forum Discussion
Calculate week evoluton
Hi, alvaro3432
Please correct me if I wrongly understand your question.
I created dim-date-table, and in Powe Query Editor, I added week-start-date-column.
I marked the dim-date-table as a date-table.
I connected the main fact table and the date table.
I used the below measures to create the below picture.
The sample pbix file's link is down below.
Previous Week Sales Total =VAR currentweekstartdate =MAX ( DatesTable[Start of Week] )RETURNCALCULATE ([Sales Total],DatesTable[Start of Week] = currentweekstartdate - 7)Other measures are shown in the pbix file.Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Super UserHi, alvaro3432
Please correct me if I wrongly understand your question.
I created dim-date-table, and in Powe Query Editor, I added week-start-date-column.
I marked the dim-date-table as a date-table.
I connected the main fact table and the date table.
I used the below measures to create the below picture.
The sample pbix file's link is down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Awesome! This woks just fine, thank you very much!
