Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

CREATE A TABLE VISUALIZATION WITH A RANGE OF DATES

Hi to everyone,      I have a table of dates (referring to transactions) and I want to create a range of dates between two specified dates. I want to visualize the result on a table visualization,...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    So, not necessarily a great solution, but you could do something like create a new column with a formula such as:

     

    Date Range = IF(TODAY()-[Date] = 0,"Today",IF(TODAY()-[Date] < 30,"< 30 Days",IF(TODAY()-[Date] < 60,"30 - 60 Days","> 60 Days")))

     

    Then, create a slicer based on Date Range. You click the slicer, it filters the visualizations on the page to those date ranges.

     

    Obviously, this does not give the user the ability to enter specific dates and such.

     

    I know that parameters or input fields have been a fairly reoccuring feature request.

aksh's avatar
aksh
Microsoft Employee
10 years ago

When I use the below formula I get an error :"A table of multiple values was supplied where a single value was expected"

 

DatesinPeriod(Table[Invoice Date],Max(Table[Invoice Date],-3,Month)

 

whereas If I use the above formula with NumberofIntervals paratmeter as 3 i.e DATESINPERIOD(Table[Invoice Date],MAX([Invoice Date],3,MONTH) , it does not throw any error

 

What is the problem?