Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to set up a flag that I can display to determine the current status of a number of projects.
My base DB is set up in this way:
I am trying to set up a way that I can tag each Project as the value in [Variable] that is based on the last date value in the [Date] column with "Actual" for [DG], per Project.
I asked around yesterday an the recommendation was three fold:
1) create a new table based on
Distinct Project Names = DISTINCT(base[Project Name])
2) create a measure in the 'Project Names' table to flag the last date entered, which matches up with the status that I am looking for. This works as intended.
3) create another measure in the 'Project Names' table to find the variable that aligns with the [cm_DGDate]. This does not work as desired, instead just returning the first unique value in variable sorted alphabetically.
I've been poking around all morning today and think that the LookUpValue function as a measure should work. But it doesn't. I need help figuring out why or a different method to do this.
This works fine when I have a filter to only one project. When I add 2+ projects to the filter it returns the error "A table of multiple values was supplied where a single value was expected".
It seems logical to me that I could add in the following arguments:
but it will not let me call the key defining column of the table.
My questions:
edit: removed amgibuity mentioned below.
please clarify if you meant calculated column or measure. The term "calculated measure" is ambiguous.
Measure.
I had it stuck in my mind that they were called calculted columns and calculated measures.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
11 | |
3 | |
3 | |
3 | |
2 |