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() )
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.