Forum Discussion
Unique values in a table
Hello All,
I have the following table:
Only one row (properties.targetresourced.id) should be returned per day (properties.activityDateTime) and application name (e.g. marketing service). For example:
B2C_f006.. - 07.11.2022 - b25b0c.. - Marketing-Service
B2C_9698.. - 07.11.2022 - 00a69e.. - Marketing-Service
B2C_85a47.. - 07.11.2022 - 98b07ab.. - Marketing-Service
Unfortunately, I'm still quite new to power bi and don't know how to solve this properly.
Do you have an idea? 🙂
Thank you very much in advance! 🙂
Hi Twychopath ,
I don´t know if you change the data type from date/time to date if it works.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Twychopath ,
I don´t know if you change the data type from date/time to date if it works.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sometimes the solution can be so simple. Thank you, it worked. 🙂
