Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Compare Data - Different Tables & multiple Rows

Hi,    I was trying to use formula previously suggested @ https://community.powerbi.com/t5/Desktop/How-to-compare-data-current-vs-previous-in-a-dynamic-table/m-p/1413821/highlight/true#M597890  but...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

i try this formula but it doesn't work. and i can't even figure out how to find previous order data 

 

Freight Total = SUM(BK_FRT[RATE])  

 

Last Order = Sumx(filter(allselected(BK_HEADER), [BK_CUSTOMER] = max([BK_CUSTOMER]) && [BK_CRT_DATE] = max([BK_CRT_DATE])),[Freight Total])

 

really need your help Greg_Deckler amitchandak Anonymous 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

If you want to compare current value and previous value, your table requires regular numeric/date value fields then you can use this field as index to looping records and get the corresponding previous values.

If not, you can try to enter to query editor and group with current table category fields and add index inside the groups, then you can get a valid index field for dax format calculations.

Numbering Grouped Data in Power Query 

Regards,

Xiaoxin Sheng