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

       

       

      • julioverdugo's avatar
        julioverdugo
        Frequent Visitor
        3 years ago

        You may need to adjust the filters for your period definition. 

        Can you provide a screenshot of your calendar table to understand the mechanic behind it and explain in more detail what is the expected output from the calculation?