Forum Discussion
Data Source change based on slicer
Dear Friends I have two excel file(have same format), one contains data upto last week and other contain data upto this week, i have many visual in my report . i need to analyse report based ...
amitchandak
Super User
Super UserAnonymous , if you have a date based on the selection
Measure =
var _max = today() + 7-1*WEEKDAY('Date'[Date],2) //this week end
return
countrows(filter(Table, Table[Date] <=_max))
Measure till last weekend =
var _max = today() + 7-1*WEEKDAY('Date'[Date],2) -7 //till last week end
return
countrows(filter(Table, Table[Date] <=_max))
Use these measures with other un summarized data
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
Dear,
Thanks for your response but i don't have date based column