Forum Discussion
Measure to compare data between two files appended into one query and distinguished by 'source name'
Hi, I have appended two files into one query. The source name column has the two source file names (File A & File B). Later in the file, I have price and volume columns. How can I create a measure on...
amitchandak
Super User
Super UserAnonymous , if these two are two tables in power bi have some common dimensions date, category , item etc
and then compare them against common dimesion
a measure like
divide(sum(FileA[Volumn]) -Sum(FileB[Volumn]) , Sum(FileB[Volumn]))
refer
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/