Forum Discussion

dennisdepoorter's avatar
dennisdepoorter
Helper I
7 years ago
Solved

Relative date filter true DAX

Hi all,   I'll try to get an additional column in my 'order product' table based on a relative (rolling) date. I tought i figgured it out, but it just don't work. Can someone help me out with the ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi dennisdepoorter,

     

    That's impossible. I have added some comments in the snapshot below. It's a COMMA in the formula while it's a DOT in the error message. 

    1. Please upgrade the Desktop to the latest version.

    2. Try this formula.

    Quantity L30D = 
CALCULATE (
    SUM ( 'Order Product'[Quantity] ),
    DATESBETWEEN (
        'Order'[ActivatedDate].[Date],
        (MIN ( 'Order'[ActivatedDate] ) - 30),
        MIN ( 'Order'[ActivatedDate] )
    )
)

    Relative_date_filter_true_DAX3

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi dennisdepoorter,

 

Is [ActiveatedDate] a column or a measure? I made a few adjustments. It worked in my test.

Relative_date_filter_true_DAX

 

Best Regards,
Dale

dennisdepoorter's avatar
dennisdepoorter
Helper I
7 years ago

v-jiascu-msft

 

ActivatedDate is a column with dates on when the order has been activated.

Thanks for the feedback all-ready, but don't work for columns that way (I think)

 
 
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi dennisdepoorter,

     

    Can you share the file? It works as both a calculated column and a measure in my side.

    Please mask the sensitive parts.

     

    Best Regards,
    Dale

    • dennisdepoorter's avatar
      dennisdepoorter
      Helper I
      7 years ago

      v-jiascu-msft

       

      The file is connected to our Salesforce enviroment... all data is confidential... is there another way?

      Maybe this printscreen of the DTB can help you out?

       

       

       
       
       
       
       
       
      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi dennisdepoorter,

         

        I created a similar model. But no issues occurred. The most important thing is it shouldn't return an error message about the MIN function. I'm very sure. I would suggest you delete it and rebuild it again.

         

         

        Best Regards,
        Dale