Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
6 years ago
Solved

Compare Data within related dates

Hi,   can we have a chance to compare values within related dates?  Table 1 and Table has relation with names table also which is unique. how can we find out results for dates? for example Result...
Need Help
  • selpaqm's avatar
    selpaqm
    6 years ago

    İ have solved my own problem with below calculated column formula.

     

     

    Column2 = CALCULATE(VALUES(Table1[Currency]),FILTER (
Table1,
Table1[Valid From] <= 'Table 2'[Date] &&
Table1[Valid To] > 'Table 2'[Date] && 'Table 2'[Name]=Table1[Name]
))<div> </div>

     

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
6 years ago

İ have solved my own problem with below calculated column formula.

 

 

Column2 = CALCULATE(VALUES(Table1[Currency]),FILTER (
Table1,
Table1[Valid From] <= 'Table 2'[Date] &&
Table1[Valid To] > 'Table 2'[Date] && 'Table 2'[Name]=Table1[Name]
))<div> </div>

 

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    selpaqm  Well done! That's basically what I was getting at, just got the column names confused. My example given just adds an extra error check to ensure that only 1 value for currency remains after all the filtering you have done, so will 100% ensure that your column evaluates properly, even if data updates cause that measure to no longer result in 1 value for currency, it will return blank rather than error as in your solution.