Forum Discussion

Gofin's avatar
Gofin
Regular Visitor
2 years ago

StartDate and Enddate.

Hi Everyone , 

 

need help in creating start date and end date columns based on Date column . If Users select start date and end date in a slicer they can see the data in a table . How to create the columns ? Date column has a date and time . So I need to show both date and time . 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Gofin , Based on Slicer values you can not create a table or column

     

    The calendar function can generate dates based on the start and end date

     

    With a slicer, you can only use in measure

     

    example

    Work Day =
    COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Min('Table'[Startdatum] ),Max( 'Table'[Slutdatum])),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))