Forum Discussion

GRT9791's avatar
GRT9791
Frequent Visitor
2 years ago
Solved

Measure - different date periods

Hello,

I need help with this issue

I have a table like this in my model PBI:

In the report, I have a slicer in order to selected different activities and a calendar table with a measure like below.

The measure must be 1 when the date is within the period of the selected activity (Initial date - End date) and 0 when it is not in the period of the selected activity (like in the image). Unfortunately, my measure works when I have selected only one activity. If I select multiple activities it doesn't work correctly

Any idea how to create the measure?

It's mandatory that the table only includes two columns (date and measure).

Thanks a lot

 

  • AilleryO's avatar
    AilleryO
    2 years ago

    Hi,

     

    We are lacking a lot of information to help you, but here are some tracks you might follow...

    1/ Maybe you can use a variable in your measure to memorize the activity "treated" and filter only on it. Then filter the next one and so on...

    2/ If your test is a calculation is it iterative, row by row ? If yes, are you using a function that iterates ?

    Hope it helps, otherwise feel free to tell us more.

1 Reply

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    2 years ago

    Hi,

     

    We are lacking a lot of information to help you, but here are some tracks you might follow...

    1/ Maybe you can use a variable in your measure to memorize the activity "treated" and filter only on it. Then filter the next one and so on...

    2/ If your test is a calculation is it iterative, row by row ? If yes, are you using a function that iterates ?

    Hope it helps, otherwise feel free to tell us more.