Tag: Unpivot Power BI

Multiple Currency Logic In Power BI – A LOOKUPVALUE Example

A really common scenario within financial analysis is having to integrate currency rates across your transactional data. Most of the time, sales data is actually recorded regardless of the currency and the currency name or code is just placed inside a column. And it could be either USD, AUD, GBP, but it isn’t actually adjusted

Continue reading

Unpivot And Pivot Basics In Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature within your data queries. One thing to bear in mind early on when working on

Continue reading