Forum

Glad I could help! Have a good one yourself as well.

DAX has many functions, and quite a few of them work the same or very similar to the ones in Excel. And why do I know about ROUNDDOWN? I guess because...

Click on the "Power Pivot" ribbon. And then "Manage" on the far left-hand side of the ribbon. That opens the Data model view and you can see the two c...

Hy Tyrone, I believe the attached file contains the type of solution you asked for. When using Power Pivot you can, indeed, not group row headers ...

According to the M function reference, the place where I entered 1 is for an "optional occurrence parameter". Even though it says "optional" one would...

Change the script to this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"N...

Hi Jojemar, First of all you need to do a full outer join. Then add a custom column that fills the null components in the first table with the comp...

Thanks for the file. Since you already started in PQ, I continued there. Though, your file connects to data on your PC and I can not work with with yo...

Have you tried a regular pivot table? If you could upload an Excel file containing a bit more than just one week of data, it would be easier to demons...

Hi David, Looked at your file but it's not clear what you want to achieve. The file includes two queries, presumably to each of the data ranges in ...

Glad I could help!

Thanks for the file. I added a few queries that create two sub-sets of the data. One for the the odd numbered rows (group1) and one for the even numbe...

Hi Andre, Would be good if you could attach your file.

Could connect to the "Fails" file without problems. It opened immediately. And it loads 13310 rows upon Close& Load, from a table called "polozka"...

Glad I could help!