Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

The TREATAS Function

Hi, I see alot of examples of TREATAS, with calculations,  but I'm trying to get a specific value from a table.
How would I get the date below, using the TREATAS function?   I see the function used for calculations and it works great for me, but not for just pulling out data from a specific record.

if it can't be done what would be an alternative?  The tables are not linked and they won't be.
Thanks.

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks Paul. I'll give it a try.  I had trouble with the first portion of the TREATAS function.
    In the first portion, the MAX(WIP Data[Epic Actual Start Date])
    I see that's how you get a single record.  Thank you!

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Treatas will allow you filter the column across table.

     

    Can you explain what do mean by get the date

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi , amitchandak.  I want to get whatever value is in the Epic Actual Start Date. Something like a lookup.
    Every example of Treatas I've seen, uses a calculation
    But what if you just want to get the value in a specific field?



  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    whatever value is in this field, i want to show the value.
    In the function lookupValue you can do a lookup . I'm looking to do the same thing with TreatAs.  

    Does that help?



     




  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    Not 100% sure how you want to materialise the "answer" but something like this:

    VAR SelectedFomattedID = VALUES( RallyEpics[Formatted ID] )

VAR Result =
	CALCULATE (
		SELECTEDVALUE ( 'WIP Data'[Epic Actual Start Date], "More than one value" ),
		TREATAS ( SelectedFormattedID, 'WIP Data'[Epic ID] )
		)

RETURN Result
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      bcdobbs, that was exactly what i want to do. I was a bit confused because of the initial portion of the TREATAS functionality. But that basically worked!


  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Try:

    epic start date = CALCULATE(MAX(WIP Data[Epic Actual Start Date]), TREATAS(VALUES(Rally Epics[Formatted ID]), WIP Data[Epic ID]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Paul. I'll give it a try.  I had trouble with the first portion of the TREATAS function.
      In the first portion, the MAX(WIP Data[Epic Actual Start Date])
      I see that's how you get a single record.  Thank you!