Forum Discussion

WLFRD's avatar
WLFRD
Helper III
3 years ago
Solved

Count rows with different dates

Hello,   can someone help me with counting rows with different dates (Date1 and Date2) in it?   Date Date1 Date2 04-Nov-22 04-Nov-22 04-Nov-22 04-Nov-22 04-Nov-22 04-Nov-22 04-N...
Need Help
  • m_alireza's avatar
    m_alireza
    3 years ago

    WLFRD ,

    Should still work. 

    If you created a table with the "Date" column and the measure, you should get a count per date, for example:

    And if you want the measure to return 0 when there is 0 rows returned (like on nov 6th in my example) then you can add a "+0" at the end of the meaure.

m_alireza's avatar
m_alireza
Solution Specialist
3 years ago

WLFRD ,

Should still work. 

If you created a table with the "Date" column and the measure, you should get a count per date, for example:

And if you want the measure to return 0 when there is 0 rows returned (like on nov 6th in my example) then you can add a "+0" at the end of the meaure.