Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Solved! Go to Solution.
If you are making it as a new column in "Export" table and there is a relationship between "Export" and "Report" then change the statement to :
If(RELATED('Previous Report'[Concat2])='Export'[concat2],1,0)
Only 1 parenthesis in the wrong place 🙂
/Adrian
Hi @sreaves,
I think you may try to use LOOKUPVALUE function.
For your sample, the calculated column may look like:
Column = IF(ISBLANK(LOOKUPVALUE('Previous Report'[Concat2],'Previous Report'[Concat2],'Export'[concat2],"NO")),0,1)
Please try.
Aiolos Zhao
Proud to be a Super User!
If you are making it as a new column in "Export" table and there is a relationship between "Export" and "Report" then change the statement to :
If(RELATED('Previous Report'[Concat2])='Export'[concat2],1,0)
Only 1 parenthesis in the wrong place 🙂
/Adrian
It looks like the extra ")" did the trick. Thanks for catching that.
Hi @sreaves,
If the answer is what you want, could you please mark it as "Acceptable Solution"?
So other people will know the question is solved.
Thanks.
Aiolos Zhao
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.