Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

undefined

How to retreive Parent start date along with time and end date along with time using child start date and child end date and also using run start date and run end date using DAX query

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Anonymous ,

     

    Will you please elborate more into what exactly you mean by Parent Date & Child Date ?

    May be you can share a image explaining the scenario, so that I can help you.

     

    Thanks,

    Bhagyashri

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I shared sample data, can you please provide solution

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I shared sample data

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Anonymous , I am not able find logic to get parent start date and end date, can you explain withe example

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    What are the relationships between these dates?

    I mean there must be some connections between columns so that we could use dax to get the value of a column according to another column.

     

    Best Regards,

    Jay