Forum Discussion
Filter table for selected Date but next year
Anonymous i do not think you can use selected value in this context, you can grab the value from selected value but as soon as you use it to filter another table, it seems to set the filter context to blank. I dont think ive ever tried as hard to solve an issue because it has me baffled but i think its the filter context of selected value is not propagated outside of the table it belongs to.
Hi vanessafvg
i now tried another way. Duplicated my orderlines table. in the duplicate i make an the following if:
FromIsNextPeriod = IF('ssbi Orderlines_dupe'[From].[Date] = [SelectedFrom_NextYear];"true";"false")Weired thing is, in the table the two values are the same, but the if says "false":
How is this possible? Both have date format, tables are not connected to each other.
Community Championcan you paste the data into the screen Anonymous
then i can try and play with it obviously its not seeing it as the same but i dont know why.
vanessafvg i created an example file: https://drive.google.com/file/d/1pcSDMLJe14DCYdZYWgCXeL8MfYCdI25h/view?usp=sharing
There is also an "expected" tab where you see my wanted result.
Let me know if you need any further infos.
Many thanks
Hi vanessafvg
Is there a reason that your answer was deleted?
Did not get it to work with your answer..
- vanessafvg
Anonymous hi yes, i realised there was something wrong with my solution, ive done a lot of digging with this and i can't quite figure out the issue but will get back to you today