Forum Discussion
pawelj795
Post Prodigy
6 years agoQuickly DAX measure fix - Filter
Hi, I want to slightly modify my measure. Currently, it looks like that: Aging = VAR ItemID = SELECTEDVALUE(WH_Invent_Trans[ItemID]) RETURN DATEDIFF(MAXX( FILTER(ALL(WH_Invent_Trans); WH...
- 6 years ago
hej pawelj795
W pliku ktory wyslales nie bylo tego obiektu wiec musiale go wylachys z formuly.
Zalaczylem plik z formua.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
Community Champion
6 years agoHi pawelj795
You can add an extra variable __date and later use it as the third argument of CALCULATE, there are three extra lines followed by "--new" in the code, this is to replace DATESYTD.
Please see the below for reference.
M =
VAR __tbl =
FILTER(
GROUPBY(
CALCULATETABLE(
WH_Invent_Trans,
KEEPFILTERS( WH_Invent_Trans[TransType] IN { 0, 9 } ),
KEEPFILTERS( WH_Invent_Trans[QTY] <> BLANK() ),
ALLEXCEPT( WH_Invent_Trans, WH_Invent_Trans[ItemID] )
),
WH_Invent_Trans[ItemID],
"@maxDate", MAXX( CURRENTGROUP(), WH_Invent_Trans[DatePhysical] )
),
VAR __days = DATEDIFF( [@maxDate], TODAY() -1, DAY )
RETURN __days > 0 && __days <= 276 --changed as 15 was out of range
)
VAR __date = MAX( DimDates[Date] ) -- new
RETURN
CALCULATE(
SUM( WH_Invent_Trans[Inventory Value EUR] ),
TREATAS(
SUMMARIZE( __tbl, WH_Invent_Trans[ItemID] ), WH_Invent_Trans[ItemID]
),
DimDates[Date] <= __date, -- new
ALL( DimDates ) -- new
)
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
If this post helps, then please consider Accepting it as the solution.