Forum Discussion
CALCULATE
- 5 years ago
Hi DagdasAlbag
I'm not sure I understand and would need more details but try this. Change the inequality sign if necessary to adapt it to your needs:
CALCULATE ( [A Number Net], FILTER ( 'qry_GivenOrders2016-2020', 'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 ) ) )It is recommended to use a date table instead of the auto Date/Time feature
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
- 5 years ago
Hi, DagdasAlbag , you may try,
CALCULATE ( [A Number Net], 'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 ) )
Hi DagdasAlbag
I'm not sure I understand and would need more details but try this. Change the inequality sign if necessary to adapt it to your needs:
CALCULATE (
[A Number Net],
FILTER (
'qry_GivenOrders2016-2020',
'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
)
)
It is recommended to use a date table instead of the auto Date/Time feature
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers