Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |