Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Community,
First time posting here as I did not see the solution to my problem..
What I need is the following:
GOAL : ‘Week over week%’ calculation under 2 conditions:
(1) Picks the most recent week of data available (avoid blank) under the selected filters (‘Year’ & ‘Month’ from the Date table)
(2) Week over week calculation takes into account the days from both current vs previous week
*I want to display the most recent Week-to-date-data on a Card automatically when choosing Year & Month on a slicer. Please see detail below:
Current environment:
Requirement (1)
****
Week Calc =
VAR CountWeeks = MAX ( dimDate [Week Relative Offset] )
RETURN
CALCULATE(
[Total QTY],
dimDate [Week Relative Offset] = CountWeeks
)
****
Requirement 2
So my goal is:
WOW% for the current week to date = ( (847+719) – (793+782) ) / (793+782)
Thank you very much in advance!!
Solved! Go to Solution.
Hi @tkwh1 see part "Week-to-date over the full previous week" and other related week calculation
from link https://www.daxpatterns.com/week-related-calculations/
I hope this help
Proud to be a Super User!
Hi @tkwh1 see part "Week-to-date over the full previous week" and other related week calculation
from link https://www.daxpatterns.com/week-related-calculations/
I hope this help
Proud to be a Super User!
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |