Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
We are migrating from Tableau, and trying to move a whole lot of reports from Tableau to PowerBI. Its mostly progressing without issues, unfortunately I got a little stuck trying to replicate a fixed lod expression which was designed to remove duplicate values in tableau - meaning if 2 lines existed the code would identify the "earliest" value and disregard the duplicate values.
The Tableau expression: (Which resulted in a True/False filter)
[txtID] = { FIXED [EAN],[Dato] : MIN([txtID]) }
I've tried a few different approaches in PowerBI but without success.
Can someone help me out?
Thanks in advance!
@RasmusLVF
Hey Mate ,
You can use this .
Test = CALCULATE ( MIN ( 'you table'[txtID] ), ALLEXCEPT ( 'you table' , 'you table'[EAN], 'you table'[Dato] ) )
'Your Table '-Name it with your Table name then followed by your column name Like 'you table'[txtID]
try this and let me know if it work for you .
Thank you Mate Cheers
Thank you for the reply.
I does appear to be working, but doesnt seem to give me the same functionality as Tableau did.
Its a somewhat complicated issue but in short, the txtid field is there to identify if the datasource came from 1 or 2 files. In case it came from 2 files, one of them will always be a duplicate and must be removed. Hence, the tableau lod calculation function was to always only include the "minimum" txtid, and exclude everything else.
In tableau, when using the calculation:
[txtID] = { FIXED [EAN],[Dato] : MIN([txtID]) }
The result was a calculated field with 2 options, True or False.
.. And I am struggling to figure out how to get the same functionality in PowerBI 🙂
I figured it out.
First:
[txtID] = { FIXED [EAN],[Dato] : MIN([txtID]) }
And then: (To create the filter)
IF(mytable[txtID]=mytable[TxtID_MIN],1,0)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
58 | |
46 | |
17 | |
12 |