Need to fill missing weekend values

Anonymous · ‎09-02-2019

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=U...

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

Anonymous · ‎02-29-2020

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

Greg_Deckler · ‎09-02-2019

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-02-2019

@Greg_Deckler -

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.