Reply
Occasional Visitor
Posts: 1
Registered: ‎12-03-2018

Week Number in direct query

[ Edited ]

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

Established Member
Posts: 200
Registered: ‎07-12-2017

Re: Week Number in direct query

Hi @pbiaddict

 

please share some screenshot of your data and the expected result

 

regards

Affan

Highlighted
Community Support Team
Posts: 1,176
Registered: ‎07-30-2018

Re: Week Number in direct query

hi, @pbiaddict

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.