Re: Date Calculation

georged018 · ‎10-04-2017

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 · ‎10-04-2017

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

georged018 · ‎10-04-2017

Can i filter between two seperate columns

Anonymous · ‎10-05-2017

@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 · ‎10-05-2017

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 · ‎10-06-2017

@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