Blog Post

Power BI Community Blog
2 MIN READ

Week Is Not So Weak: WTD, Last WTD, and This Week vs Last Week

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago
Objective: We would like to have WTD(Week Till Date) Last WTD and This Week vs  Last Week. Dataset: We have taken Sales data. The data is from April 2018 till April 2020. We have created a date Cal...
Updated 6 years ago
Version 2.0
DAX
power bi
Power BI Desktop
Time Intelligence
Working with Non Standatd Periods
amitchandak's avatar
Icon for Super User rankSuper User
Joined June 27, 2019
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
HH-HELD's avatar
HH-HELD
Regular Visitor
3 years ago

Hi amitchandak

I tried the "Week Start Date" function but got the error message below. My "date" dataset looks fine. Would you please advise what I need to do to proceed? Thank you very much in advance!

 

ERROR MESSAGE: "A single value for column in table cannot be determined..."