Forum

I'm not aware of an option that lets you convert a pbix file to xlsx. The OP in the thread you referred to used Power Query within Power BI to connect...

Can't test it but the && logical operator equals an AND. Since you seem to need an OR, use || (a double pipe). More on that in the link below...

Please try sending the attachment again. don't forget to press "Start upload" before submitting your reply.

Loaded your file and for me the DATA column is at the far right. Can't tell why you have it on the left. But does it matter?

Let's say you have a column with the first three characters for each month (Jan, Feb, Mar etc.) Using these in pivot tables will put them in alphabeti...

Can imagine you could use Power Query to connect all files in a folder that contain the periodic files. Combine them into one large table for the year...

You don't mention how the underlying data is structured, but perhaps you can keep the data for all periods in one large table and then create the pivo...

That I understood, but what would be the end result in the example you posted earlier? Sorry for being slow 🙂

Thanks for the file. And what would be the expected result?

No sample was attached. Try again and don't forget to press "Start upload" before submitting your reply.

That formula seems to work just fine for me, though it's not very dynamic due to the hard-coding of both the conditions "A,B,C,D,E " and the outcome i...

I'm afraid your particular situation isn't suitable for PQ then. Unless I'm wrong. In that case I'll leave it to someone else to resolve, Sorry.

You raise many questions that aren't easily explained. I'm really sorry for that. But regarding you very last comment "how that then updates the origi...

Thanks for the file. That helped. The attached file contains a working solution. I created some intermediate steps and helper queries that perhaps...

Perhaps I just don't understand your intentions or the work-flow you are describing. I thought you were suggesting to update the original source with ...