Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Not showing data properly

I'm new to Power BI, but I've used other BI solutions in the market.   Anyway, I have a situation where I can't seem to work out. I've made a simplyfied example so someone can understand and help m...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Either you have move price from one table another like these example

New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])
New Column = maxx(filter(table1,table1[Col1]= earlier(table1[col1]) && table1[Col1]= earlier(table1[col2]) ),table1[required_col])

 

Or group data at purchase ID

Something like this

sumx(summarize(Purchase[Purchase ID], "_sum", count(ID), "_price",max([price])),[_sum]*[_price])

 

But Purchase ID should be in common dim or taken from the master table

 

Refer : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451