Forum Discussion
Solved
Count Based on Date in the same Table
I have a Table with the below structure: ID - Date 1 - 1/Jan/2020 1 - 2/Jan/2020 2 - 1/Jan/2020 3 - 1/Jan/2020 4 - 5/Jan/2020 ... Where ID appears multiple times. I need a measure in a Ta...
Hi Neqom ,
Here's my modified data, otherwise unchanged.
Just select Show item with no data in the ID field and now, IDs with no counts in the last 30 days show blank.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Note* Example asuming that Today = 10/Jan/2020