12-03-2018 03:03 PM - edited 12-03-2018 03:04 PM
I am having a power bi dashboard with data from SSAS direct query. I have dates in the facts table. I want to add a new column in this same table wich has the week number. I can do this in power query but for that I need to have imported data.
Thanks for any help.
12-04-2018 06:29 PM
For you are having a power bi dashboard with data from SSAS direct query. you couldn't add a calculate column.
You could try these two ways:
1. add week number column in data source (SSAS).
2. use this formula to create a week number measure instead of column
Measure = WEEKNUM(SELECTEDVALUE('Table'[Date]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.