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()
    )
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

I'm sure you could use power automate

to recalculate a sheet.

 

If I were you though I'd pull the raw data table in and write a measure to reproduce the logic inside power bi.

unde2667's avatar
unde2667
New Member
4 years ago

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?

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    I'd probably do something like:

    Current Primary = 
    CALCULATE (
        SELECTEDVALUE( Assignment[Primary Individual] ),
        Assignment[Date Start] <= TODAY(),
        Assignment[Date End] >= TODAY()
    )
    • bcdobbs's avatar
      bcdobbs
      Community Champion
      4 years ago

      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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    Share some data, describe the question and show the expected result.