Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Correct date with Dax multiple records

Hello, Is there a way to build a Dax formula to give me the # of Days based on the Target Start Date and Target End Date (per below table)? So, I put a graph and the days based on a dates table the ...
vapid128's avatar
vapid128
Icon for Solution Specialist rankSolution Specialist
4 years ago

Jane Smith would return 4 (# of Days) for Jan 1 - 24

 

what is the relationship between 4 and jan1 jan24?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    vapid128  4 would be the # of days according to the table if I wanted to chart it on a graph for 2022 that would be the result I want for Jan 1 - 24 as the Target on the 2nd line says its effective from Mar 15 2018 - Jan 24 2022.