lookupvalue Query

[gmazza76]

Good Afternoon,

I am new to the Power BI world and could do with a hand if possible.
I currently have a table that has continual data that updates on a weekly basis and need to have my main table read from this based on the
"AccNo", "contacttype" and "date".

Currently when I use this function it confirms the equation cannot be done as the account number is duplicated more than once.
For me to reduce this is there anyway I can include an AND function to restrict the date it would look at.

ie AccNo = Match
Contacttype = match
Date = Day -1 to D+5 of the Date I have in my actual table

something like
=LOOKUPVALUE(Table1[issue_date],View[account_number],Table1[accnumber],View[letterid],Table1[letterid],and(View(Issue_Date]>=Table1[Issue_date]-1,View(Issue_Date]>=Table1[Issue_date]+5))

Or is there a more sensible way of doing this. I currently rank the data and search via a concatenate of the information, but this only leaves me with the most recent information, where as I need the file to be an ongoing file instead of a week or a month.

thanks in advance
Gavin

 

[gmazza76]

I think this is done via an INDEX and MATCH in excel, but I am unsure of the equivalent in Power BI

thanks