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
Noelle's avatar
Noelle
Helper I
5 years ago

Thank you Anonymous . I must do something wrong, since I keep getting the same result 😞

 

Relationships :

Main : 'DATE DE PRODUCTION'[Date]->'Feuil1'[Date]

Second : 'DATE DE PRODUCTION'[Date]->'Feuil1'[Date -6]

 

Nbre de Rx = COUNTROWS('Feuil1')
Nbre de Rx -6 = CALCULATE(COUNTROWS('Feuil1'),USERELATIONSHIP('DATE DE PRODUCTION'[Date],Feuil1[Date -6]))

 

Can you see what's my mistake?

Thanks

Noelle

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Noelle 

     

    I have no idea...it looks like the same, but it works in my sample file...I can send you the .pbix file if you need, you can pm your email address