Forum Discussion

jcrodriguez's avatar
jcrodriguez
Frequent Visitor
8 years ago

Data in Column Changes each Period - Forecasting - Infor LX Database - function needed for Power BI

Hello All,   I am fairly new to the forum. Forgive me if this has been covered; however, I do not know how best to describe my problem without providing sufficient details.    Background: At my ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi jcrodriguez,

 

It's hard for me to imagine your scenarion without any data. And your actual environment looks like complex. Would you please provide some dummy data? Also, please make your requirement more specific rather than tell us a general request for a report. You could follow this blog to provide some information. 

 

Best regards,

Yuliana Gu

  • jcrodriguez's avatar
    jcrodriguez
    Frequent Visitor
    8 years ago

    Hi v-yulgu-msft

     

    Thank you for your guidance. 

     

    JFI looks like this when exported into Power BI:

     

     

    so the top table is the JFI and the bottom table is called the KMR. In the system the KMR is static while the JFI is dynamic due to the fact that when I run my forecast at month end.

     

    basically -> month end is ran -> March Forecast Data moves to last position in the forecast history group (F1H112) -> April Forecast moves to current forecast (F1F11) position. The process will repeat at month end when April Forecast moves to forecast history and June forecast replaces it in the forecast position (F1F11).

     

    I need a way to be able to calculate a stastic number against a dynamic number. basically if I wanted to find the difference between March Forecast in JFI against the March forecast in the KMR, even when March Forecast in JFI moves at the month end when the new forecast pushes the old data into a different column.

     

    Hope this helps explain it out further.

     

    Thanks!

     

    Kind regards,

    Jose