Forum Discussion
Solved
Getting PowerBI to show current excel function that uses today() expression
My PowerBI pulls from about 8 excel files. One of the things it returns is the name of someone assigned to a certain date range. This comes from an excel sheet where names are assigned to weeks and I...
I'd probably do something like:
Current Primary = CALCULATE ( SELECTEDVALUE( Assignment[Primary Individual] ), Assignment[Date Start] <= TODAY(), Assignment[Date End] >= TODAY() )
That makes sense to just have it look it up within PowerBI... Thanks! I'm not great with DAX, can you help with the equation? in Excel it's
=LOOKUP(2,1/($A$29:$A$34<=TODAY())/($B$29:$B$34>=TODAY()),$C$29:$C$34)
Within PowerBI, would it be a "lookupvalue" function?
Hi,
Share some data, describe the question and show the expected result.