Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I have two tables with the same keyfield.
Table_1 contains facts and the keyfield exist more than one time.
Something like this:
Key, Dimension, Value
1011322|2 WA 4004.28
MR181152|5 OI 35.23
MR181152|5 WA 1366.06
MR189911|7 OI 70.32
MR189911|7 WA 858.08
MR20009222|2 WA 164.58
MR20014782|2 SVO 112.5
MR20014782|2 SVI 135
MR20014782|2 WA 584.34
MR20015293|4 WA 987.48
Table_2 contains the number of objects on a certain date.
In my dashboard i use a single select on the Date field. So, every keyfield exists once after the selection.
The table looks like this:
Key, Date, NoOfObjects
1011322|2 1/31/2021 98
MR181152|5 1/31/2021 1
MR189911|7 1/31/2021 1
MR20009222|2 1/31/2021 2
MR20014782|2 1/31/2021 2
MR20015293|4 1/31/2021 12
What i want is to add a calculated column to add the number of objects, 'on the fly', to Table_1.
Everytime that the user changes the Date selection, the column must change.
Thanks for your help,
Halmar
Solved! Go to Solution.
What i want is to add a calculated column to add the number of objects, 'on the fly', to Table_1.
Everytime that the user changes the Date selection, the column must change.
Calculated columns are immutable. They cannot be influenced by user filter choices. Rethink your requirement.
What i want is to add a calculated column to add the number of objects, 'on the fly', to Table_1.
Everytime that the user changes the Date selection, the column must change.
Calculated columns are immutable. They cannot be influenced by user filter choices. Rethink your requirement.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |