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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        georged018,

        Create a column using the following similar formula.

        Column = IF(MONTH(Table7[Resolved Date])=8 || MONTH(Table7[Closed Date])=8,1,0)

        Regards,
        Lydia