Forum Discussion

aref_tashnizi's avatar
aref_tashnizi
Frequent Visitor
2 years ago
Solved

not using date slicer but instead allow user to enter from a date picker for start and end date

How to create a Start Date and an End Date without using a slicer from a single column from a Fact table? I have a column called DIM_DATE[CALENDAR_DATE] which is linked to a fact table. What I woul...
  • mariussve1's avatar
    2 years ago

    Hi,

     

    This is possible to achive. Then you need two date tables.

    This two tables cant have any relationships to the fact, just be stand alone.

     

    Then you need slicers, one for each data table so the end user can pick from - and to date.

     

    At last you need to create a measure on the fact table with the correct aggregation (sum, count or What you need), with a filter Where start date is >= the first date end user pick and end date <= the other.

     

    Br

    Marius