Forum Discussion

unde2667's avatar
unde2667
New Member
4 years ago
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...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    I'd probably do something like:

    Current Primary = 
    CALCULATE (
        SELECTEDVALUE( Assignment[Primary Individual] ),
        Assignment[Date Start] <= TODAY(),
        Assignment[Date End] >= TODAY()
    )