Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating calculated column with if condition based on quarter difference

Hello All, I have below table in my power bi file. Customer name Onboard date Users added date total users ABC 01 January 2022 01 January 2022 20 ABC 01 January 2...
Need Help
  • lukiz84's avatar
    lukiz84
    4 years ago

    Add a column

     

    DiffInQuarters := DATEDIFF([Onboard date], [Users added date], QUARTER)

     

    and move on from there. The rest should be easy.

     

    br

lukiz84's avatar
lukiz84
Memorable Member
4 years ago

Add a column

 

DiffInQuarters := DATEDIFF([Onboard date], [Users added date], QUARTER)

 

and move on from there. The rest should be easy.

 

br