How do i fix the dates column in power bi ?

[Anonymous]

Hi 

My problem is that i need to show this week sales along with this week dates . suppose this week contains 

these dates . so i want to show the dates for this week . if there is no sales on particular date that data should be blank or 0.00.

Please help me with the solution 

[Icey]

Hi @Anonymous ,

In what specific scenario do you want to achieve this requirement? Could you give me a sample? Then I can provide a more suitable solution.

Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , we can have following columns

start week = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
end date= 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)

and filter for this week

In case you want measure then, refer

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8