Forum Discussion

sd0021781's avatar
sd0021781
Regular Visitor
1 year ago
Solved

Net Login calculation

Hi,   Need help   I have net login without aux in my excel file >> when i am using it after uploading in Power BI, It is not allowing me to calculate average, both the screenshot are attached for...
Need Help
  • sd0021781's avatar
    sd0021781
    1 year ago

    Thanks,

     

    I got my answer with below mentioned syntax

     

    Average Time W/O Aux = VAR FilteredTable =     FILTER(         'One View Noida',         'One View Noida'[Net Login without Aux] <> TIME(0, 0, 0)     ) VAR AvgTime =     AVERAGEX(         FilteredTable,         'One View Noida'[Net Login without Aux]    ) RETURN     FORMAT(AvgTime, "HH:MM:SS")
     
    Thanks
sd0021781's avatar
sd0021781
Regular Visitor
1 year ago

Thanks for your revert.

Please find below the error i can see.

 

 

shafiz_p's avatar
shafiz_p
Super User
1 year ago

Remove extra brackets after AM/PM

 

  • sd0021781's avatar
    sd0021781
    Regular Visitor
    1 year ago

    removed the extra bracket. still their is no change

    • shafiz_p's avatar
      shafiz_p
      Super User
      1 year ago

      again remove extra bracket ] in first line after 'One View Noida'[Net Login Without Aux]

      You formula for measure may not work. As I can see that you have used original time column inside averagex. You first need to create a column to convert "Net Login without Aux] to TimeinDecimal. 

      Follow steps I have provided. To create column, see the image below:

       

      first click number 1 and then write formula in number 2. exactly same just need to change column name.

       

      Hope this helps!!

      • sd0021781's avatar
        sd0021781
        Regular Visitor
        1 year ago

        Not it is showing Sytax Error