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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Maffimau,

Can I "simulate" or "forced" a value "0" when I have no dates or without rows?

Could you try adding "+ 0" to the end of the formula of your measure to see if it works? :smileyhappy:

measure = COUNT(<column>) + 0

 

Regards

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