Week Number in direct query

[Anonymous]

Hello

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.

pbiaddict

[v-lili6-msft]

hi, @Anonymous

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]))

Best Regards,

Lin

[affan]

Hi @Anonymous

please share some screenshot of your data and the expected result

regards

Affan