Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone I have this problem with lookupvalue:
The formula is:
Fecha recepción esperada = LOOKUPVALUE('Fitflow$Purchase Header'[Expected Receipt Date] ; 'Fitflow$Purchase Header'[No_] ; 'Fitflow$Sales Line (2)'[Nro de PC])
All of that lines below have the same'Fitflow$Sales Line (2)'[Nro de PC]) and as you can see this formula just return some of them and others in blank. Why it is happening? All the lines should have the same value. I need your help.
Thank you for your quick response.
Hi @JEANCARLOB7
1. The table you are showing is 'Fitflow$Sales Line (2)', correct?
2. Where is the column 'Fitflow$Sales Line (2)'[Nro de PC]? Can you show it?
3. Can you show the table you are trying to read from, 'Fitflow$Purchase Header'? Including columns 'Fitflow$Purchase Header'[Expected Receipt Date] and 'Fitflow$Purchase Header'[No_]?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
HI @AlB
Acoording to the questión 1 , yes the table showed previously is 'Fitflow$Sales Line (2)',
I leave you what is required:
'Fitflow$Sales Line (2)' --->many registers
'Fitflow$Purchase Header' ---->one register
Relationship
I will be attentive to your prompt response
Hi @AlB
I found the solution. The relationship was the problem between purchase line table y purchase header. This relationship has to be unidirectional not bidirectional
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |