Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
@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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The measure are values aggregated for each day, and also have a timestamp column to indicate when the data was uploaded. The table used to generate the workweek just has a single timestamp column recording when each data upload happened.
@Anonymous something I'm missing here,please share sample data and if there are more than one tale shre relationship diagram, and also what measure you are using in matrix/
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous works for me, just added ww and new measure you provided earlier.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
That's really strange. Under visual level filters for WW, it shows that there's only a single WW 18.5 as well, but it still subbornly displays a duplicate WW 18.5 value
@Anonymous yes, that's why i'm having hard time understanding why it is showing duplicate, try new matrix visual, or open/close file, or just start new file, very hard to pin point what is the actual issue.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Not sure if it makes a difference, but the measures are pulled from different tables. They're all in the same format as the one with cb and cs I sent previously, and display summations of values from the exact same timestamp. All the timestamps from different tables are identical though - data from different tables are all uploaded with identical timestamps recorded.
@Anonymous well without knowing how those table are related and what these measures are, hard to tell. seems like i'm not seeing the full picture. may be is possible send pbix file wiht sample data, keep tables the way it is , otherwise we are just going in circles.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Maybe there is an easier way - is there a way to filter the date column in Powerbi, so that there is only 1 entry per day, and all other entries on the same day is removed/hidden?
Here are some sample timestamps that are used to generate the workweek columns:
timestamp
2019-04-02 11:50:54 AM
2019-04-04 11:51:11 AM
2019-04-05 1:54:26 PM
2019-04-09 4:36:07 PM
2019-04-17 4:42:15 PM
2019-04-23 3:40:11 PM
2019-05-01 4:41:51 PM
2019-05-02 1:50:22 PM
2019-05-03 3:35:03 PM
2019-05-03 4:16:43 PM
WW = FORMAT(WEEKNUM([timestamp],2),"General Number") & "." & WEEKDAY([timestamp],2)
Here's some sample data for 2 of the metrics where cs and cb are being displayed in the matrix, for the dates WW18.5.
The actual display is actually a summation of all the cs/cb values that have the exact same timestamp:
CALCULATE(SUM([cb]), FILTER('table','table'[timestamp]=MAX('table'[timestamp])))
timestamp | cs | cb |
2019-05-03 16:16 | 747 | 272 |
2019-05-03 16:16 | 1 | 1 |
2019-05-03 16:16 | 1 | 1 |
2019-05-03 16:16 | 8 | 1 |
2019-05-03 16:16 | 6 | 1 |
2019-05-03 16:16 | 2 | 2 |
2019-05-03 16:16 | 2 | 2 |
2019-05-03 16:16 | 2 | 2 |
2019-05-03 16:16 | 2 | 2 |
2019-05-03 16:16 | 5 | 2 |
2019-05-03 16:16 | 38 | 2 |
2019-05-03 15:35 | 1 | 1 |
2019-05-03 15:35 | 8 | 1 |
2019-05-03 15:35 | 6 | 1 |
2019-05-03 15:35 | 2 | 2 |
2019-05-03 15:35 | 2 | 2 |
2019-05-03 15:35 | 2 | 2 |
2019-05-03 15:35 | 2 | 2 |
2019-05-03 15:35 | 5 | 2 |
2019-05-03 15:35 | 38 | 2 |
2019-05-03 15:35 | 4 | 2 |
2019-05-03 15:35 | 4 | 2 |
2019-05-03 15:35 | 12 | 2 |
2019-05-03 15:35 | 6 | 2 |
2019-05-03 15:35 | 1 | 2 |
2019-05-03 15:35 | 3 | 3 |
2019-05-03 15:35 | 7 | 3 |
2019-05-03 15:35 | 10 | 3 |
2019-05-03 15:35 | 4 | 3 |
2019-05-03 15:35 | 10 | 3 |
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |