topic Re: Need to fill missing weekend values in DAX Commands and Tips

Need to fill missing weekend values

Anonymous — Mon, 02 Sep 2019 23:58:10 GMT

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.

Re: Need to fill missing weekend values

Greg_Deckler — Tue, 03 Sep 2019 03:26:47 GMT

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

Re: Need to fill missing weekend values

Anonymous — Tue, 03 Sep 2019 03:56:50 GMT

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.

Re: Need to fill missing weekend values

carolinastalo — Fri, 28 Feb 2020 13:03:19 GMT

Hi, Did you solve this? Have a similar problem

Re: Need to fill missing weekend values

Anonymous — Sat, 29 Feb 2020 20:20:03 GMT

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