Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to use this function to plot a chart for weekly sales and getting this error. I dont know how I can use Power Query as suggested here or whether it is a right answer.
Can someone point me to right place?
Thank You,
Vishal
Solved! Go to Solution.
Hi @vopatel,
To return weeknum values for dates in Query Editor, we can create a custom column below:
But Please note, as it's DirectQuery mode, it's not able to apply this change after add this custom column, you can see below message when you apply query:
In your scenario, I would suggest you use T-SQL query to return weeknum values:
Best Regards,
Qiuyun Yu
Hi @vopatel,
To return weeknum values for dates in Query Editor, we can create a custom column below:
But Please note, as it's DirectQuery mode, it's not able to apply this change after add this custom column, you can see below message when you apply query:
In your scenario, I would suggest you use T-SQL query to return weeknum values:
Best Regards,
Qiuyun Yu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |