Showing Historical Trends

[johnbradbury]

I have a report which shows the current open volumes for certain categories. I want to add a visual to the table which shows the historial trend from the previous week. This would be a green down arrow, or a red up arrow.

My data structure is essentially looks at a single sheet called 'Current'. When I add new data for the next week I rename that sheet WK1, WK2 etc... I then add the next or current data to 'Current'.

I have a very limited knowledge of DAX.

[Eric_Zhang · Accepted solution]

---

@johnbradbury wrote:

I have a report which shows the current open volumes for certain categories. I want to add a visual to the table which shows the historial trend from the previous week. This would be a green down arrow, or a red up arrow.

My data structure is essentially looks at a single sheet called 'Current'. When I add new data for the next week I rename that sheet WK1, WK2 etc... I then add the next or current data to 'Current'.

I have a very limited knowledge of DAX.

---

@johnbradbury

You'll have to append the different sheets into one and add "weekNo" field to distinguish data. Alternatively, you can rename the sheets as "current","previous","wk1" etc and then always retrieve data from those two sheets in Power BI desktop.