Hi @PaulBoyes , Enterprise DNA have contents that could help with your concern, here are some similar topics covered in the forum, kindly check them below. Thanks
Why do you have the ABS there?
I’m not sure that is needed here and is likely why it’s causing the problem I think.
Dear all,
In reference to the link of the original post below, would there be a way to branch this measure out to support WK number & Day of Last year?
Link to Original Post:
From the original measure of PY Sales Setup, I tried to add ‘Date’[DayInWeek] as a new variable but the outcome was not what I wanted. Below screenshot for reference.
Modified Measure
[Capture]
Modified Outcome
[Capture]
Advance thanks for the help all!
Regards
Hidayat
Looking for DAX formula to compare total services of a selected week(s) with last year same period. For example, I like to be able to compare total services (count) of service Week 1 January 2018 with Week 1 January of 2017. Week starts with first of the month + 7. So, week 1=1 thru 7, week 2 = 8 thru 14, week 3 = 15 thru 21, week 4 = 22 thru 28 and week 5 = the rest. I will use the week variable in filter along with service year and month.
I have looked at comparing current year or even curren…
I am trying to create a expression to compare sameperiodlastyear at a fiscal week level.
The calculation I tried (below) does not return the correct value.
Total Sales LY = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( Dates[Date] ) )
My data is at a fiscal week level, and does not have standard calendar dates
For example, I need to compare Fiscal Week 201701 to Fiscal Week 201601, but the fiscal week begins in February. I would like the calculation to be dynamic so that I can look at last 2…
1 Like