Show (and rank) largest account balance moves Today Vs. Yesterday

[#1]

Hi,

I'm trying to figure out how to show account balance moves (today vs yesterday), and then rank them, showing the biggest movers in ascending order.

For some reason I cannot get my formula to work, returning null values instead. Any ideas?

sum({<Date={$(=Date)}>}Accountbalance)) - (sum({<Date={$(=Date-1)}>}Accountbalance))

Thanks in advance,

Olle

[#2]

Tried it, but now It cannot find the fields for the Temp2 load.

[ashfaq_haseeb]

Hi,

Try below

Temp2:
NoConcatenate
LOAD
   Date,
    num(Date) as NumDate,
    ClientName,
   Balance

Resident ColumnHeader; 

Drop Table ColumnHeader;

Regards

ASHFAQ

[#4 · Accepted solution]

Do this . Delete everything else

ColumnHeader:
LOAD [date dd.mm.yyyy] As Date,

     Num([date dd.mm.yyyy]) As NumDate,
     [Client no] as ClientNumber,
     [Client name] as ClientName,
     [delivery system] as System,
     [Product name]as ProductName,
     [branch no] as BranchNumber,
     [account no]as AccountNumber,
     [balance in EUR] as Balance

FROM

(ooxml, embedded labels, header is 2 lines, table is [balance amounts end of day]);

[#5]

Perfect, thanks a lot Syed!

[#6]

Also, I have another question. Regarding Weekdays.

Will post it in a new discussion thread.

//O