cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

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.

StevenT_0-1647522916092.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!

View solution in original post

7 REPLIES 7
PaulDBrown
Community Champion
Community Champion

Try:

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

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!

bcdobbs
Super User
Super User

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


Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Anonymous
Not applicable

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!


Anonymous
Not applicable

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?



StevenT_0-1647542033939.png

 




Anonymous
Not applicable

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?



amitchandak
Super User
Super User

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

 

Can you explain what do mean by get the date

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors