Filter Calendar lookup table based on fact table value

NegaStar

New member
Joined
Nov 3, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019 (Office 365)
Hi All,
I would like to ask your help to find a solution of the following case.
I would like to get the minimum Calandar[Date] value which is equal or greater than TransctionPast[FirstValid] date.
Here are the relationships:
medium

I created the following measure but it just uses a lot of RAM without any result, when I tried to put it in it in a power pivot's value section
medium

I think it is caused by the relationship and the filter direction but I can not figure out how to get the required date value.
I would use it for further calcualtion which will be in the value section of a power pivot.
Could you help me to define the required measure? Please see the sample file on the following link. Thank you very much in advance!
Power Pivot Sample


 

RET

New member
Joined
Nov 29, 2020
Messages
27
Reaction score
0
Points
0
Location
Spain
Website
informaticamuyfacil.com
Excel Version(s)
2019
Not fully sure, but try:

VAR MinFirstValid = MIN(TransctionPast[FirstValid])
RETURN
CALCULATE(MIN(Calendar[Date];
FILTER(Calendar;Calendar[Date]>MinFirstValid)
)
 
Top