Forum Discussion

Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

Count rows with same value in one column

Hello,   I have a column "Valuation date" with dates like: 2024-02-06 2024-02-06 2024-02-06 2024-02-07 2024-02-07 2024-02-07 2024-02-09 2024-02-10 2024-02-10 2024-02-12 2024-02-12 2024-...
"Need Help"
Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

bhanu_gautam gmsamborn 

 

yes, exactly, that does not work as a measure because it "refers to an earlier row context which doesn't exist." But I do not need to have it as a calculcated column, if I have it as a column, I get numbers from the ground table (which has more rows than my visual) and not from my visual.

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi Shota_Xuc 

 

Try changing EARLIER to MAX.

  • Shota_Xuc's avatar
    Shota_Xuc
    Icon for Helper I rankHelper I
    2 years ago

    Hi gmsamborn MAX does not work either, as you see I get 2 instead of 3 for 2024-02-06, 4 instead of 1 for 2024-02-09, 6 instead of 2 for 2024-02-13 and etc.