Forum Discussion

Haya's avatar
Haya
Helper II
6 years ago
Solved

Show Tasks in specific month using date slicer

I have the following table as an example   Task Assigned to Start Date End date Duration Task 1 Haya, Sara 2/15/2019 4/15/2019 60 Task 2 Ali 1/1/2020 5/1/2020 120 Task 3 Sa...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Haya 

     

    Based on your description, I created data to reproduce your scenario.

     

    You may create a Date table as follows.

     

    Calendar = CALENDARAUTO()

     

     

    Then you can create a measure as below.

     

    IsProcess = 
var _mindaterange = 
CALCULATE(
    MIN('Calendar'[DateRange]),
    FILTERS('Calendar'[DateRange])
)
var _maxdaterange = 
CALCULATE(
    MAX('Calendar'[DateRange]),
    FILTERS('Calendar'[DateRange])
)

return
IF(
    NOT OR(_maxdaterange<MAX('Table'[Start Date]),_mindaterange>MAX('Table'[End Date])),
    1,0
)

     

     

    Finally you need to put the measure to the visual level filter. Here are the results.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Haya 

try this

 

Create calender table and don't connect it with any other table.

ADD date column in between slicer.

 

Create measure,

Measure=Sumx(table,if(Table[End date])<=MAx(date[Date]) && Table[End date])>=Min(date[Date]),1,0)

 

Add this measure to visual level filter and set it to "is not 0".

 

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Anonymous wrote:

    Hi Haya 

    try this

     

    Create calender table and don't connect it with any other table.

    ADD date column in between slicer.

     

    Create measure,

    Measure=Sumx(table,if(Table[End date])<=MAx(date[Date]) && Table[End date])>=Min(date[Date]),1,0)

     

    Add this measure to visual level filter and set it to "is not 0".

     

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

    Have you tried this solution?

     

    Thanks,

    Pravin