Dateadd

C

cajste

Board Regular
Joined
Oct 22, 2012
Messages
67
Hi,
Can anyone explain why this DATEADD formula returns max of actual arrival in the present month instead of max of actual arrival for the previous month?
CALCULATE(MAX(V_LocoKPI[ActualArrival]);DATEADD(Dim_DatesArrival[Date];-1;MONTH))
//Caj
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

brendalpzm
  • Question Question
Gallery not filtering properly
Replies
0
Views
216
brendalpzm
brendalpzm
P
  • Question Question
MAD not calculating correctly when using a 6 month rolling average
Replies
0
Views
421
peterr2006
P
M
  • Solved
Calculating Same Day Last Week only works partially in Power BI
Replies
2
Views
509
muhammadahmad21
M
C
  • Question Question
Power BI - 2 fact tables to use same month end date
Replies
7
Views
336
Matt Allington
M
M
  • Question Question
Latest Weeks Volume Issue with DAX
Replies
2
Views
139
JEC
JEC

Forum statistics

Threads
1,223,955
Messages
6,175,605
Members
452,660
Latest member
Zatman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top