Hi, I am completely new to all of this! So please bare with me.
I have table as follows
Property Code - Total Period Charge - VOID Code - VOID Description - VOID Phase Sequence - First Phase Start Date - Last Phase end Date
I added an additional column using the following:
(Column) Days Void = 1.* 'Void Phase analyses'[Last Phase End Date] - 'Void Phase analyses'[First Phase Start Date]
This worked and now my new column tells me how many days void there has been.
So my questions is:
I want a column to tell me the number of days Void for each of the VOID Code categories.
In the Void Categories column is different codes for Read to Let, Minor Repair, Major Repair, Do Not Use etc.
but I cant write something that tells me if [VOID Code] = MINRP (or MAJRP or DNU etc.) then [Last Phase End Date] - [First Phase End Date] = the days it was void (according to the reason it was void).
any help in leading me in the right direction would be much appreciated.
Kind regards
