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 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 :smileyhappy:

5 Replies

  • 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?

      • 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