Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |