Forum Discussion
ArjanL
8 years agoFrequent Visitor
Three different filtered visuals based on one slicer
Hello, I am new to Power BI and struggling to achieve the following. I have contracts with a starting date and a termination date. SO: ContractA 2015-10-05 2016-07-17 ContractB 2016-04...
ArjanL
8 years agoFrequent Visitor
This is close to what I need, but I bump into another problem.
This function allways returns the first contract that meets the requirements.Say both ContractC and ContractD are active in 2016, I only get ContractC as a return.
For testing I made a calculated column with the formula and a fixed year.
And with an AND statement I added Contract[No_]=EARLIER(Contract[No_])
Then I get the Contract No of the current line as return value, what is what I want.
So, I tried this in the measure, but then I get the error that EARLIER points to a row context that does not exist.
Is there another way to make sure I only get the current row as a return?
v-huizhn-msft
Microsoft Employee
8 years agoHi ArjanL,
Do you mind share your .pbix file for further analysis?
Thanks,
Angelia