Forum Discussion

jb123's avatar
jb123
Frequent Visitor
9 years ago
Solved

Add column for Last Week to table

Hi,   I want to add a custom column to a table that will list the words Last Week.  I want to add this column so I can add slicer to the report so the users can filter to see just last week's data....
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    jb123

     

    Hi, add a custom Column:

     

    = Table.AddColumn(#"YourPreviousStep", "LastWeek", each if Date.IsInPreviousWeek([Date]) then "Yes" else "No")

Nayan_surya's avatar
Nayan_surya
Helper I
2 years ago

Hi  jb123 ,

 

This is a good approach but becomes impractical when you need like combination of these kinds of filters. I had faced a similar situation previously and what we ended up doing is getting a custom visual named Date picker by Powerviz. 

It had all the required features like

Multiple presets,

Default selection

Holidays

Invalid dates highlight and much more

So final result, the client was happy.

 

 

 

I think you should check them out.

Here is a link if you want to check this visual - https://appsource.microsoft.com/en-us/product/powerbivisuals/truvizinc1674781244292.date-picker-by-p...  (I believe they offer a free version too)