Forum Discussion

prashantg364's avatar
prashantg364
Helper II
1 year ago
Solved

DAX

  Based on Date selection my Table is created for the selcted dates. now i want to add 2 more columns in my table, first column: Delta of column 1& Column 3 (i.e Delta of 27-1-25 & 3-2-25) ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi prashantg364 

    This one is quite tricky and complex. It involves a disconnected table that contains all possible date combinations of column1 vs. column3 and column2 vs. column3, along with the actual date columns. Additionally, there's another disconnected table for the dates to be compared. It's challenging to explain the process in detail, so please refer to the attached PBIX file for a clearer understanding.

     

danextian's avatar
danextian
Super User
1 year ago

Hi prashantg364 

This one is quite tricky and complex. It involves a disconnected table that contains all possible date combinations of column1 vs. column3 and column2 vs. column3, along with the actual date columns. Additionally, there's another disconnected table for the dates to be compared. It's challenging to explain the process in detail, so please refer to the attached PBIX file for a clearer understanding.