Forum Discussion
Merge in Power query editor
I made it,
1. Read data from excel
2. create two reference on first step
3. first reference have min value QMIN
4. second reference hva max value QMAX
5. Merge QMIN Left Outer Join QMAX
6 In new table I get wrigth values from QMAX
This is frist Query:
QMIN:
QMAX:
From bouth Query remove last two columns, and Attribute Split with "/" separator and replace QMIN with START and QMAX with END:
QMIN:
QMAX:
Merge LEft outer JOin
First Row tabel values:
Everthing is nice with problems.
But After Expand last row, get same Value as from QMIN query:
I schould get from QMAX Value, which is Ok in step before Expand.
I get here same VAlue from QMIN Value column.
Bet regards
How it looks in tables:
Its wrong after merge, green is ok red is wrong
- krekandus3 years agoRegular Visitor
hier should You find file PBIX
https://drive.google.com/drive/folders/1tOzSgK8gANfLMQ5YNLsBfdrMVpvccnLK?usp=sharing