Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
@Anonymous , Treatas will allow you filter the column across table.
Can you explain what do mean by get the date
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!