Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Icon for Helper I rankHelper I
5 years ago
Solved

CALCULATE

Hello,   I want to create a measure that shows me the values before the 01.07.2020 and a second one that shows me the values before the 01.07.2020 (see appendix). -> CALCULATE([A Number Net],FILTE...
  • AlB's avatar
    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 

     

  • CNENFRNL's avatar
    5 years ago

    Hi, DagdasAlbag , you may try,

    CALCULATE (
        [A Number Net],
        'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
    )