Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago

Apply filter on two date column

Hi, I have table with Order date and sale Date, now I want to know, order date vs sale date values.  But when i am using DATEADD function over Calendar table, it consider only Order Date, not going to Sale date.

 

Product - Order Date count - Sale Date count

ABC -  20 - 15
DEF - 30-30
XYZ - 20 - 10

Need Help

2 Replies

  • nvprasad's avatar
    nvprasad
    Solution Sage
    5 years ago

    Hi,

    You can establish an inactive rlationship with the sale date column with the date table and while the calculating value in the measure use "USE RELATIONSHIP" function to turn the inactive relationship into active.

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

    • vijayvizzu's avatar
      vijayvizzu
      Helper III
      5 years ago

      I tried it, its not working, my purpose is (in excel term, if i filter on Order date as May 2021 (assume count of 30 records), then i want to count the records on Sale order date column for previous month (Apr 2021 records).

       

      Hope its clear to you