Forum Discussion

khenning's avatar
khenning
Frequent Visitor
9 months ago

Lookup Visual Calculation not working correctly

Gurus - I am in need of assistance.   Hopefully the table above is showing up.  I'm working on a matrix visual, each month going across with various details in each row.  I need to create a fi...
Need Help
v-hjannapu's avatar
v-hjannapu
Community Support
9 months ago

Hi khenning,
you want to carry forward the previous month’s calculated value and use it for the next month, like how we do in Excel.In Power BI, this can’t be done directly because DAX doesn’t calculate row by row like Excel. The LOOKUP function will only pick the data from your table, not the value that was calculated in the previous month.To get the same result, we’ll need to create a proper date table and use a running total type of formula with CALCULATE and FILTER.

please go through with the below document hope it may resolve your Issue.   https://learn.microsoft.com/en-us/dax/runningsum-function-dax

Hope this helps if you have any queries we are  happy to assist you further.
Regards,
Community Support Team.

khenning's avatar
khenning
Frequent Visitor
9 months ago

Thank you for the information.  I'll just work out how to get the data within the view in Oracle before I load it into PBI.

 

 

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    9 months ago

    Hi khenning,
    Thank you for the Update If you face any issue later while loading or checking data in Power BI, feel free to ask here  we will help you out.

    Regards,
    Community Support Team.