Forum

Please see file attached which is close to what you want. I used the technique for numbering grouped data in Power Query. Hope that helps. Mynda

Hi John, Maybe you can use Power Query's Fuzzy Matching. Mynda

Hi Amanda, Have you checked the licensing requirements just above the video on the Power BI Organizational Data Types post? Mynda

"And do I have to add in the calendar the working days?", yes, that is the missing piece of the puzzle. It's not clear what this represents e.g. worki...

Hi Chris, Welcome to our forum! Unfortunately, the Power Query window locks Excel, so there's no way to get around it. If you have two screens, ...

Hi Johan, Please explain how you get the working days value? It is nowhere in your model. Please also show an example where you calculated DOH for ...

I'm not sure I follow the strange behaviour, but it sounds like maybe you are using fields in your row/column labels that are from one of the fact tab...

Hi Amanda, Have you considered using Power BI data types, which are explicitly designed for this purpose? See the link for a tutorial and example. ...

Glad we could help 🙂 Power Pivot is the data model, so I'm not sure what you mean exactly. Perhaps this video on Power Query vs Power Pivot will ...

Hi Johan, Please upload the file again. Be sure to click the 'Start Now' button and wait for the grey check mark beside the file size to indicate i...

Hi Eun, Dynamic array formulas cannot spill in Tables. In other words, you cannot write a dynamic array formula in a Table. This is simply a limita...

Hi Cristina, Not sure why you're using ADDRESS for this. It's best to use INDEX or OFFSET to write dynamic named ranges. Mynda

Hi Manoj, You didn't read the 'Note' in my reply where I said you don't need the capacity stored in the demand table. I just put it there to illust...

Hi Matthew, You can use SUMIFS referencing dates. e.g. =SUMIFS(B2:B8,C2:C8,">="&G1,C2:C8,"<="&H1) However, the data in your att...

Hi Jorg, You can also ensure background refresh is turned off in the query options. Query editor File tab > Options and Settings > Query Opti...