Forum Discussion

NickProp28's avatar
NickProp28
Post Partisan
5 years ago
Solved

Needs historic data + refresh data

Dear Community,    I have been creating a report which needs to show the whole status for the products. For example raw data during the week 1.   During the week 2, after I refresh the raw...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi NickProp28 ,

     

    According to your description, similar results may not be achieved in powerbi. In powerbi, the best way is to continuously update the status results and keep records in the form of rows. Then create a column and use the CONCATENATEX function to show the entire change process in the card visual. If it is only updated in the original row, it will not be saved.

    just like:

    Col = 
CALCULATE (
    CONCATENATEX (  'Table','Table'[Status]  , "->" ),
    ALLEXCEPT ( 'Table', 'Table'[Product] )
)

     


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Calvin69's avatar
Calvin69
Helper III
5 years ago

Hi NickProp28 ,

What is your original data source location? Is it a manually controlled excel sheet or is it a system table of some kind?

Can you provide more details please?

H

  • NickProp28's avatar
    NickProp28
    Post Partisan
    5 years ago

    Dear Calvin69 ,

     

    Thank for your attention.

    I will retrieved the data from database.
    And is only have these two column, and I would like to store the historic data when I perform the weekly updates.

    • Calvin69's avatar
      Calvin69
      Helper III
      5 years ago

      Hi NickProp28 ,

       

      I am not 100% sure, perhaps someone else can assist further with your query however, I recently had a similar situation with a data set that was located on Sharepoint and I was able to activate the historical records and pull out the historical entries to work with in PBI.

      I would suggest that you query the data at source to generate a consolidated table entries before importing it into Power BI.

       

      Good luck

      H