Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DateTrunc

Hello,  I have the following report query from Solarwinds and would like to replicate it within Power BI.   SELECT Interfaces.InterfaceId, Nodes.NodeID, Nodes.Caption AS NodeName, Nodes.Details...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I am trying to pull 95th percentile for the previous month. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am trying to pull 95th percentile for the previous month. 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    It seems that you want to convert the query to dax in power bi.

    You could refer to this article at first.

    In addition, you could try MONTH () to replace DateTrunc('month', GETUTCDATE()).

    If you still need help, you'd better share some data sample and your desired output so that we could help further on it.

    Best  Regards,

    Cherry