Forum Discussion
Display each day only once
Hello,
I'm using a matrix display with workweek (weeknum.weekday) as columns using the equation
WW = FORMAT(WEEKNUM([timestamp],2),"General Number") & "." & WEEKDAY([timestamp],2)
If there are multiple entries in timestamp that are the same day, I get duplicate workweek columns.
Is there a way to display only once (the latest in the same day)?
Thanks.
12 Replies
- parry2k
Super User
Anonymous can you share sample data and what you expect the result to be. read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi parry2k
Here's a sample from the timestamp table
In this case, there are 2 entries in the database from May the third (which gets transformed to week 18 day 5 using the dax equation mentioned previously. On the table, there is now a second column labeled 18.5 - I'd like there to only be one - each column represents one day, and there should not be duplicates if the timestamp columns has multiple entries for that particular day.
- parry2k
Anonymous i don't expect to see two columns.
so you are using matrix visual, and putting this week column on columns, what is your measure?
