Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all!
I have an excel sheet that records sales by date: DD-MMMM-YYYY
I can easily extract week number from the date column using PBI.
but how to tell PBI that my week starts Saturday and ends Thursday (Only Friday as a weekend)?
Many thanks in advance.
Solved! Go to Solution.
Try the following
WeekDay = WeekDAY(yourTable[yourDate],16)
This is a replication of WeekDay function in excel. You can check out using excel to see the different options.
PowerBI Dax only shows 1,2,3.
If this solves your issue please accept this as a solution and give KUDOS.
Cheers
CheenuSing
Try the following
WeekDay = WeekDAY(yourTable[yourDate],16)
This is a replication of WeekDay function in excel. You can check out using excel to see the different options.
PowerBI Dax only shows 1,2,3.
If this solves your issue please accept this as a solution and give KUDOS.
Cheers
CheenuSing
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |