Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Compare all values in column from one table with single value from other table

Hi,    I've the next doubt: suppose that I have these tables, Dates and Projects:   Dates Date 1981-01-01 1992-02-02 1993-03-03 2018-04-04 2019-04-04   Projects Identifier     Name      ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi PattemManohar . First of all, thanks for your early response. I have a doubt related to Date field. How can I invoke it? Shoud I invoke it as Dates[Date]? In that case, PowerBI alerts me that a single value for Dates[Date] cannot  be determined. What's wrong with this?

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous  Could you please post the screenshot of the error message. Yes, it is Dates[Date]. I just referenced as [Date] as it is within the same Filter Context.