Forum Discussion
Advanced Data columns in a table
Hi all,
I am quite new to Power BI and I have one report which I would like to automate if possible.
This is a table which in terms of rows is easy to configure, however in terms of rows its a bit hard.
In the raw data we have - Day, Month, Week, Year as separate columuns so that we we want to achieve is a table which looks like this:
It like if we are able to have columuns with a week value which can be expanded to daily value.
Hope I managed to explain what we need.
Many thanks in advance!
BEst regards,
Ivan
You can use the WEEKNUM() function:
WEEKNUM(<date>, <return_type>)https://docs.microsoft.com/en-us/dax/weeknum-function-dax
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
I have some progress..
I found this feature "
Drill down on column headers"
The issue now is that I cant get the Weeks in the Data Hierarchy.
Thats what I have displayed in the fields section:And heres what I have in the raw data:
Now if I use Month, Week, Date it gets confused and shows the months as follows - December, February, January
If I get the time hierarchy I dont have the weeks.
Any advices?
many thanks!
You can use the WEEKNUM() function:
WEEKNUM(<date>, <return_type>)https://docs.microsoft.com/en-us/dax/weeknum-function-dax
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the reply! This works and adds the week, however still doesnt manage to get a good visual in Power Bi Matrix
