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
I have a table with a large number of rows from data recorded at very close time intervals.
In the screen-shot below, I have a number that I'd like to round up a few decimal points and then flter to remove duplicates based on two of the columns combined (Horse Name & UTC Time).
Horse Name is in the 1st column in the screen-shot below.
The example of the "UTC Time" shown below is (1) 42862.50367 in the table and (2) 42862.5036666667 when I inspect it.
What I'd like to do is round up the above example to 42862.504.
In doing so, I'll wind up with duplicates (of Horse Name & UTC Time), so I'd then like to filter the combination so I wind up with records that are unique by Horse Name & rounded UTC Time.
I'm sure there's a way to do this but I can't seem to figure it out.
I'll appreciate any assistance.
Thanks, Mark.
Solved! Go to Solution.
Hi @Skemaz,
In the querry editor add a custom column with:
Number.Round([UTCTime],2)
Then use that column to remove your duplicates.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Skemaz,
In the querry editor add a custom column with:
Number.Round([UTCTime],2)
Then use that column to remove your duplicates.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix
Many thanks for helping.
Best regards, Mark.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |