Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am having following table, I want the 'Value' column to be filled for VCF and VCT based on Value of VCL where SO,BN and MV is same for VCL,VCF and VCT.
Name | Col1 | SO | BN | MN | Value |
VCL | 5449 | 11315906 | C721578E | MS6108005EN | A1 |
VCF | 2048 | 11315906 | C721578E | MS6108005EN | |
VCT | 2745 | 11315906 | C721578E | MS6108005EN | |
VCF | 6374 | 11327179 | C721578G | MS9666005EN | |
VCT | 2048 | 11327179 | C721578G | MS9666005EN | |
VCL | 1765 | 11327179 | C721578G | MS9666005EN | A2 |
The output table should be
Name | Col1 | SO | BN | MN | Value |
VCL | 5449 | 11315906 | C721578E | MS6108005EN | A1 |
VCF | 2048 | 11315906 | C721578E | MS6108005EN | A1 |
VCT | 2745 | 11315906 | C721578E | MS6108005EN | A1 |
VCF | 6374 | 11327179 | C721578G | MS9666005EN | A2 |
VCT | 2048 | 11327179 | C721578G | MS9666005EN | A2 |
VCL | 1765 | 11327179 | C721578G | MS9666005EN | A2 |
experts, please help me on this. @amitchandak, @parry2k
Solved! Go to Solution.
Hi, @pathakpeeyush
Your column type is "text", I would suggest you to use [Value]=" " to replace isblank([Value]
So please change your formula of calculated column as below:
Value2 = if([Value]="",MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value])
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@pathakpeeyush , Try a new column like
if(isblank([Value]),maxx(filter([MN] =earlier([MN]) && not(isblank([Value]))),[Value]),[Value])
I tried this insted-
Hi, @pathakpeeyush
Your column type is "text", I would suggest you to use [Value]=" " to replace isblank([Value]
So please change your formula of calculated column as below:
Value2 = if([Value]="",MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value])
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for responding. It's showing error msg as- Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |