Dates help

[Anonymous]

Hello Experts,

I am beginner to Power BI and need help on dates. My requirement is like below. I have dates columns and need percentage column based on dates populated / available in column.

Please help.

column1	column2	column3	column4	column5	column6	requirement
A	B	7/5/2021	7/15/2021	7/31/2021	8/5/2021	100% ( I need here 100% if all dates are populated)
C	D	7/5/2021	7/15/2021	7/31/2021		75% (I need here 75% if column 3 to column 5 are populated)
E	F	7/5/2021	7/15/2021			50% (I need here 50% if column 3 and column 4 are populated)

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Column = 
    VAR __Table = { [Column3], [Column4], [Column5], [Column6] }
RETURN
    COUNTROWS(FILTER(__Table,[Value]<>BLANK()))/4

Might consider unpivoting your date columns.

[Anonymous]

Thank you so much Greg.