Forum Discussion

Noelle's avatar
Noelle
Helper I
5 years ago

Count rows at different time zone

Hello,   I would like to count rows on a production sheet, every day. I need to count rows from 6am to 6 am, and show it on a graph with usual date 12pm to 12pm. I have on the same table a column ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Noelle 

 

I have done one like this, you can use two tables as well

Relationships

Number of op = COUNTROWS(factTable)

Number of op -6h = CALCULATE(COUNTROWS(factTable),USERELATIONSHIP(dimTable[start date/time],factTable[Date - 6h]))