Trend Analysis
Hi Guys, Asking the community for help, I've a coloumn which has inconsitent data however it has keywords which i'll be using in the "cards" for visualization such as "ABC" and "XYZ". So when I click on the card "ABC" the "clustered bar chart" should change according to the data and show the trend. I was thinking to seperate the column with all "ABC" in one column and "XYZ" in another" however I am finding it impossible to do it as has 20k+ rows and too many words/letter/delimiters in between "ABC" and "XYZ". Sample data is below Can you guys help please? Any help is greatly appreciated. Margins ABC 10days ABC XYZ 64 minutes ABC Remote work Internal Job ABC External Job XYZ ABC half 2020 New postpaid work
7 day moving average
I really have zero DAX experience. I even tried to add a column and then enter an Excel formula at first. Of course after digging in a little I realized that it doesn't work that way in this case. I am using direct query from a SQL database. My query data looks like the below table - and I am trying to add the final 7 day moving average column. In short, I need to sum the quantity ordered on each date and then calculate the 7 day moving average on those sums. I would then add that data to the line graph below. What is the best way to go about doing this? In addiiton, is there a particular trainng course I can take to come up to speed?
On-premises Power BI Report Server connect live to an on-premise python or analysis server
Currently, I'm publishing dashboards on the on-premises Power BI Report Server. via SQL Enterprise. Edition. is there an on-premise python or analysis server? so can i run advance analyses live from the Power BI Report Server dashboard.
