Forum Discussion
Week Values From Date Table Show Up Multiple Times
So I have a regular Date Dimension in Power Bi. There is a week column for each date in the date dimension. However, if I place the week into a column in a table or matrix, each week shows up multip...
Hi DataBulbsBiz ，
This is my test data.
Table = ADDCOLUMNS(CALENDAR(DATE(2023,1,1),DATE(2023,12,31)),"value",1,"weeknum",WEEKNUM([Date],2),"weekday",WEEKDAY([Date],2))Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried your solution to see that it produces the exact same issue as described? If you have not tried, it is not helpful to offer it to others as a solution.