Forum Discussion

ssspk's avatar
ssspk
Helper III
2 years ago
Solved

Previous rows value based on date (Nested Window Function from Azure DatbricksSQL in Power BI logic)

Hi, How to achieve the values from previous row in Power BI (which means nested window functionality in Azure databricks). I can exectre the query and display the results in Azure databricks. I wou...
Need Help
Tips and Tricks
  • ssspk's avatar
    ssspk
    2 years ago

    Created a mew measure for the colum and used the Fn like below. Its working,

    RunningTotal = CALCULATE (
        SUM ( [EventsCount] ),    
            ALL ( data_customized ),
            data_customized[servertime] <= EARLIER (data_customized[servertime]))
    Thank you.
ssspk's avatar
ssspk
Helper III
2 years ago

Hi Tharun,

Thank you for reply.But i am getting the below error.

Attached image for your reference.

 

Thank you.

 

tharunkumarRTK's avatar
tharunkumarRTK
Super User
2 years ago

Hi 
You are creating a caculated column, I gave an example syntax for measure. 
Also, while writing the measure I assumed that you have a measure called EventsCount 
if that is not the case then please create the measure first.

  • ssspk's avatar
    ssspk
    Helper III
    2 years ago

    HI,

    Tharun Thank you for your reply and time. I am a new bee to the topic.

    yes its a calculated column.

    For new colum i have used like below,

    = Table.AddColumn(#"Renamed Columns", "RunningTotal", each CALCULATE([EventsCount], Filter(Allselected(data_customized) , Table[servertime] <=Max(Table[servertime]) )))

     

    Atached images for your reference,

     

    Thank you.

  • ssspk's avatar
    ssspk
    Helper III
    2 years ago

    Hi Tharun,

    I am getting the below error in the Table view itself.Attached screen shorts.

     

    Its says cannot found or may be not used in the expression is thrown.

     

    Thanks in advance.