Forum Discussion

jansenuy's avatar
jansenuy
Helper I
9 years ago
Solved

Display data for the past weeks

Hi so I have a problem automating my graphs/visuals to display data for the 6 six weeks automatically or even a measure (sales) of the latest week. I tried making DAX or custom column, but I had no s...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jansenuy's avatar
    jansenuy
    9 years ago

    Just for everyone's reference, I was able to do it by putting my weeks in the filter and then filtering it using "Top N" then setting it to a number then choosing last weeks in the setting below it. Pretty straightforward.

jansenuy's avatar
jansenuy
Helper I
9 years ago

dearwatson Yes I understand how useful it could be to have a date dimension, but my data isn't really that date friendly. The only dates colums I have are the following:

 

Year: xxxx

Year/Month: xxxx/xx

Year/Wk: xxxx/xx

 

Now from there, I do not know how Power BI can extract date.

 

Also, I tried using this DAX measure as a work around:

 

FFE wk4 = FILTER('Master Data','Master Data'[Week]=(WEEKNUM(TODAY())-1))

 which means like filtering the dataset to the week before this week

 

but I get this error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

 

Thanks so much.

 

jansenuy's avatar
jansenuy
Helper I
9 years ago

Just for everyone's reference, I was able to do it by putting my weeks in the filter and then filtering it using "Top N" then setting it to a number then choosing last weeks in the setting below it. Pretty straightforward.