Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have this calc column to only show previous week.
Week Begins on Monday - >
Solved! Go to Solution.
@Qotsa -
It looks good to me. Only difference I see is:
VAR Current_Week = CALCULATE ( MAX ( [Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
versus:
VAR Current_Week = CALCULATE ( MAX ( vw_ShiftsAll[Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
Maybe you have something else going on that needs to be known?
Proud to be a Super User!
Hey,
this DAX statement works in my calendar tables:
isInPreviousWeek = var someTestDate = today() -7 var SoWDatePrevWeek = someTestDate - WEEKDAY(someTestDate,2) + 1 var SoWDate = 'Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1 return IF(SoWDatePrevWeek = SoWDate, 1,0)
Basically I use this statement to flag some days in my calendar table with flags like
-1 for the previous week
0 for the current week
1 for the upcoming week
Regards,
Tom
Hey,
this DAX statement works in my calendar tables:
isInPreviousWeek = var someTestDate = today() -7 var SoWDatePrevWeek = someTestDate - WEEKDAY(someTestDate,2) + 1 var SoWDate = 'Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1 return IF(SoWDatePrevWeek = SoWDate, 1,0)
Basically I use this statement to flag some days in my calendar table with flags like
-1 for the previous week
0 for the current week
1 for the upcoming week
Regards,
Tom
@Qotsa -
It looks good to me. Only difference I see is:
VAR Current_Week = CALCULATE ( MAX ( [Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
versus:
VAR Current_Week = CALCULATE ( MAX ( vw_ShiftsAll[Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
Maybe you have something else going on that needs to be known?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |