Forum Discussion
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...
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.
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