Date Calculation

[georged018]

Hi All

I new to Power BI  so please bare with me 

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 period and i am looking to do this using the two date fields, Rolved and Closed.

i think i need to create a new column with an IF statement, If Resolved or Closed within Month x or is there a way i can group dates between two seperate columns?

any help would be great 

[nogi]

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

[georged018]

Can i filter between two seperate columns 

[v-yuezhe-msft]

@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]

Hi @v-yuezhe-msft

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.

 

[v-yuezhe-msft]

@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