Forum Discussion

Nethunt's avatar
Nethunt
Frequent Visitor
8 years ago

Report data from same week previous year

Appended dataqueries from several companies to a new query in Power BI. Every company query has almost the same columns (YearWeek, SalesTotal, SalesA, SalesB, SalesC, ........). Before appending i ...
Need Help
Nethunt's avatar
Nethunt
Frequent Visitor
8 years ago

Thanks for replying. 

 

For the expected result see chart in reply from today.

Simplified the GROUP query is as follows

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the data in an Excel or .pbix file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      I get a message saying that i do not have permission to download the file.

      • Nethunt's avatar
        Nethunt
        Frequent Visitor
        8 years ago

        Sorry - first time i used google-drive this way. 

         

        testdata