Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
3 | |
2 | |
2 |