Forum Discussion

Maffimau's avatar
Maffimau
Frequent Visitor
9 years ago

Powerbi.com Server Time

Hi, I did a big report with a lot calculation based on now() function (hour, average time for a operation, ecc..). After published the report I dicover that the database are in Irland -2 hours from ...
Need Help
Maffimau's avatar
Maffimau
Frequent Visitor
9 years ago

Hi, thanks for the suggest but I tried and I can not do it because:

I have a clumn that is a result from a sql tabel throw 5 filters! So if I use the function "count" the result is from the original table without filters; does it mean that the result have to be "1" (from the table with filters), but with "count" function the result is 96K.

I don't know if there is a trick to "count" with few filters in the same function, and the filters come from interrogation to others table of sql.

Thanks

dmvega's avatar
dmvega
Frequent Visitor
9 years ago

Does anyone know if this is going to be fixed? This is a problem becuase I use some views/page/report filters that uses the advanced filter option to see data from yesterday, but at 7pm local time the data in server shows no info because I am -5GMT and server is in UTC, and I have no idea how to fix this.

 

Regards

 

Diego