Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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!
Try:
epic start date = CALCULATE(MAX(WIP Data[Epic Actual Start Date]), TREATAS(VALUES(Rally Epics[Formatted ID]), WIP Data[Epic ID]))
Proud to be a Super User!
Paul on Linkedin.
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!
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
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!
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?
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?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
49 | |
45 | |
38 | |
37 |