2 Replies Latest reply on Nov 21, 2016 10:49 AM by mircea.rusu.0

    DAX CALCULATE equivalent in Tableau?

    mircea.rusu.0

      I am trying to migrate some PowerPivot queries to Tableau. This is the DAX function that we need an equivalent:

       

      =CALCULATE (

          COUNTROWS (Table1),

          FILTER (

              Table1,

              (       Table1[Submitted_Date] >= Table2[Start Month]

                  &&  Table1[Submitted_Date] <= Table2[End Month]

      &&  Table1[Closed_Date] = 0

      && Table1[Cancelled_Duplicated_Date] > Table2[end Month])

          )

      )

       

      Regards,

      M.R.