Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I have a table (Versions) like:
NAME / Start / End
Version1 / 1.1.2010 / 31.7.2015
Version2 /1.8.2015 / 31.3.2016
Version3 /1.4.2016 / 1.12.2016
I also have a date in an another table (Requests):
Request / Created / Version
Issue1 / 1.2.2015 /
issue2 / 1.5.2016 /
I need to find correct version.
I have a filter like
Solved! Go to Solution.
@Anonymous Please try this as a New Column... "SELECTCOLUMNS" will do the trick for you...
Version = SELECTCOLUMNS(FILTER(Test248Versions,Test248Requests[Created]>=Test248Versions[Start] && Test248Requests[Created]<=Test248Versions[End]),"Name",[Name])
Proud to be a PBI Community Champion
@Anonymous Please try this as a New Column... "SELECTCOLUMNS" will do the trick for you...
Version = SELECTCOLUMNS(FILTER(Test248Versions,Test248Requests[Created]>=Test248Versions[Start] && Test248Requests[Created]<=Test248Versions[End]),"Name",[Name])
Proud to be a PBI Community Champion
You formula works like a charm, thanks!
If I have OVERLAPPING events - I am getting this error:
"A table of multiple values was supplied where a single value was expected."
If I don't care which event to show - how can I handle this?
I tried MAX() but didn't help
Thanks
Michael
Hi,
Share some data and show the expected result.
Thank You very very much!!!! 🙂
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |