The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi guys, could you please help me with this scenario? I got a table below which I created a calculated columns that is returning current week + future 12 weeks. It is working fine. However, I would like to add a date filter, this time want to see the same logic if I select previous date. Say if I select January 1, 2023, it will show me Jan 1 + future 12 weeks data.
Could you please confirm if this is possible? This is my current measure which is not showing progress at all.
Test =
VAR ReferenceDate = SELECTEDVALUE('Date'[Date])
VAR PreviousDates =
DATESINPERIOD(
'Date'[Date], ReferenceDate,3,MONTH)
VAR _Weeknum =
WEEKNUM( 'Date', 1 )
VAR _Weeknumtoday =
WEEKNUM( TODAY(), 1 )
VAR Week_Filter = SELECTEDVALUE('Date'[Start of Week])
VAR _Weeks =
CALCULATE(
Weeknum >= Weeknumtoday
&& Weeknum <= Weeknumtoday + 12)
VAR Test =
CALCULATE([Incomings], FILTER('Date','Date'[Date] >= _Weeks && 'Date'[Date] <= ReferenceDate))
RETURN
_Weeks
@Jiji0129 , if I select a date and need more than that, them My Slicer should be independent date table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max1 = maxx(allselected(Date1),Date1[Date])
var _min = _max1 - weekday(_max1,2)+1
Var _max = _min + 7*12 -1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Also check
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8