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,

Below code works for my problem and displays the Running total properly.

As solution,

 

RunningTotal = CALCULATE (
    SUM ( [EventsCount] ),    
        ALL ( data_customized ),
        data_customized[servertime] <= EARLIER (data_customized[servertime]))
 
Thanks