Forum Discussion

georged018's avatar
georged018
New Member
8 years ago

Date Calculation

Hi All   I new to Power BI  so please bare with me :smileyhappy:   Trying to work out how to do a calculation on two dates. What i am looking to do is analyse incidents closed within a time perio...
nogi's avatar
nogi
Advocate II
8 years ago

Does it need to be in a new column/table? Why not just use the filters and filter by date?

  • georged018's avatar
    georged018
    New Member
    8 years ago

    Can i filter between two seperate columns 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      georged018,

      Could you please share sample data of you table and post expected result here? What do you mean that group/filter dates between two separate columns?


      Regards,
      Lydia

      • georged018's avatar
        georged018
        New Member
        8 years ago

        Hi Anonymous

         

        What we are trying to occomplish it track closed incidents which have been either closed or resolved within a particular month. This data is recorded under Resolved Date or Closed Date. As the dates are different we are unable to just use the one field so was looking to use a combination of both.