Previous date - dax - power bi - measure

[neobaron]

Hello everyone,

I need a way of get the SUM of the previous date, it couldn´t be previuos month because could be a difference of day. I need it for detect how is changing % from the last date.

I need it for POWER BI

Thanks!!

 

[Mackers]

Hi neobaron

So that we can try to help, please could you clarify what you want the formula to do, including an example of expected inputs (dates) and your expected output (is it a percentage or a number or a date?).

Thanks

Mackers

 

[neobaron]

Hello Mackers,

First of all thank you for your reply,

I am working with POWER BI Designer (But at the end is DAX & PowerQuery) I am getting my data from several .csv files. Each one have one date created (That is the date that´s matters for me).

I.E: Three dates 01/05/2015 - 06/05/2015 - 24/05/2015. Each date is a .csv file and have its rows, and a amount. I want to compare the amount of each one of them in refence to the date before % But i only find the way of do that if they come from one month before. What i need is something like the PREVIOUSMONTH but PREVIUS DATE, or something like the EARLIER but with measures because now it is not working.


What i have right now to see the values of each date is that formula:

Savings = CALCULATE(SUMX('Main Data','Main Data'[Savings Total]), LASTDATE('Main Data'[Download Date]))

 

[scottsen]

I would make a calc column that "ranks" the Download Date... using RANKX. That would let easily switch to the previous date with a "minus 1".