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?
I'd probably do something like:
Current Primary =
CALCULATE (
SELECTEDVALUE( Assignment[Primary Individual] ),
Assignment[Date Start] <= TODAY(),
Assignment[Date End] >= TODAY()
)That creates a measure which would display todays primary. If that's all you need then just drop it in a card visual.
If you have more complicate needs downstream of that then give some details.