Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dates help

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. Ple...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Maybe:

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

    Might consider unpivoting your date columns.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Maybe:

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

Might consider unpivoting your date columns.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you so much Greg.