Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Week Number in direct query

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    Hi Anonymous

     

    please share some screenshot of your data and the expected result

     

    regards

    Affan

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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