Forum Discussion
Need to fill missing weekend values
Hello,
I am very new to Power BI, DAX, and everything else. I think I have a simple problem, however, I'm unable to come up with the answer.
I receive an email each morning ( Monday - Friday excluding holidays ) with data in an excel sheet. I have set up a Microsoft Flow to put the data in my Sharepoint. When I refresh my Power BI Desktop, it brings in the most recent data. https://netorgft4389539.sharepoint.com/:x:/s/PTEG/Ecah8tQYglZAn6P12egYCgkB9KpEVKiv0PCBCX6dJkNj3A?e=UYZBeG
These daily Excel sheets have the forward electricity pricing for each Zone, each Strip, for each of the next 60 months. 915 individual data points for each day I would receive the email. I need to have the Values for each Zone, Strip, Forward Month and Year, from Friday ( or any day that I wouldn't receive an email like a Holiday mid-week ), to show in the Table.
Ideally, I think this would be best to do in Power Query, but I can do it in DAX if that is what's recommended.
Screenshot of PBI Canvas
4 Replies
- Greg_Deckler
Community Champion
OK, so for the weekends, what would your price be? The price as of the last date you received data? Any chance you can post the data in text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Yes. The last date I would receive the data.
Typically I get the data Monday - Friday, outside of any holidays during the workweek.
I'm not sure what you mean Post the Data in Text? I attached the last data I got from Friday (8/30/19). I didn't receive any data for today, due to Labor Day. So that means I would want Friday's Values shown for Saturday, Sunday, and Monday.
Hi, Did you solve this? Have a similar problem
- You are absolutely right - THIS SHOULD BE DONE IN POWER QUERY because PQ is the tool specifically designed to deal gracefully with such problems. DAX is a data analysis expression language and the name says it all. It's not a data mashup language. Such a language is M which is the language behind PQ.
Best
D
