Forum Discussion

Dichilyn1's avatar
Dichilyn1
Frequent Visitor
3 years ago

Tabular Editor: Non-Standard Calendar time comparisons/Conditional calculation with filters

Hi All,    I am looking to transition from creating redundant time comparison measures (that require a lot of copy and pasting for measure creation) to utilizing tabular editor.    A couple of ca...
Need Help
julioverdugo's avatar
julioverdugo
Frequent Visitor
3 years ago

Based on your screenshot, you need to replace the SELECTEDMEASURE() right after the CALCULATE statement with the DIVIDE statement below. 

 

Let me know if this solves the issue.

 

Best,

 

JV.

  • Dichilyn1's avatar
    Dichilyn1
    Frequent Visitor
    3 years ago

    The error now says Error on L13Wk Expression: The end of the expression was reached.

    • julioverdugo's avatar
      julioverdugo
      Frequent Visitor
      3 years ago

      Try this: 

      VAR CurrWMWK =

          SELECTEDVALUE( 'Calendar'[WM Chronological Order])

      RETURN

         IF(

              ISSELECTEDMEASURE([OH Qty], [OH Cost], [POS Qty]),

              CALCULATE(

                  DIVIDE( SELECTEDMEASURE(), COUNTROWS('Calendar')), --or the calendar table you need

                  FILTER(

                       ALL('Calendar'),

                       'Calendar'[WM Chronological Order] <= CurrWMWK - 1

                       && 'Calendar'[WM Chronological Order] > CurrWMWK - 14

                 )

              )

          )

      • Dichilyn1's avatar
        Dichilyn1
        Frequent Visitor
        3 years ago

        It accepted the DAX, but the output doesn't seem to be reacting to the if statement and the values are not as expected