Forum Discussion
Hi Guys
V-lid-msft,
thank you for your solution.
Please how about if I want to look in column "Pricing entry date" for tomorrow dates only if they exist.
For example if today is 29.01.2020, I want the script to look only for 30.01.2020 between start date and end date from the referance file.
Can you help please?
Thank you,
Sarmad Dara
Community SupportHi Anonymous ,
We can add a condition to meet your requirement:
Column =
CALCULATE (
MAX ( 'Table 2'[Subtotal 4 = NIV] ),
FILTER (
'Table 2',
'Table 2'[Customer L8] = [Customer Number ]
&& 'Table 2'[Pricing entry date] >= [Price Valid from]
&& 'Table 2'[Pricing entry date] <= [Price Valid to]
&& 'Table 2'[Pricing entry date] = TODAY() + 1
)
)
Best regards,
v-lid-msft , Thank you for your reply, please i noticed you didnt use referance table in your query. when I applied your requery I get an error.
Note your query in table 1 (reference table) is not used in the query to link the two tables
= CALCULATE
( MAX
( 'Table 2'[Subtotal 4 = NIV] ), FILTER ( 'Table 2', 'Table 2'[Customer L8] = [Customer Number ]
&& 'Table 2'[Pricing entry date] >= [Price Valid from] && 'Table 2'[Pricing entry date] <= [Price Valid to]
&& 'Table 2'[Pricing entry date] = TODAY() + 1 ) )Thank you,
Sarmad Dara