previousday

4 Topics

question about using PreviousDay function
I have a simple measure that is supposed to return the previous days number for a count of apps that meet a certain criteria. At first, I tried this dax expression: Apps previous day = Calculate( count(data[app Number]), Previousday(date DIM [Date])) This expression does not return an error, but it also does not return any values. I was able to get the measure to work properly by using: Apps Previous Day = CALCULATE( COUNT(Data[app Number]), FILTER( ALL('Date DIM'), 'Date DIM'[Date] = Today() -1 ) ) However, I am confused why the first dax expression does not work. Especially since Microsoft's publishing of the previousday function seems to imply that it should. https://learn.microsoft.com/en-us/dax/previousday-function-dax Would anyone be able to help me understand why the first dax expression does not seem to be working properly? Thanks,
Solved
LeeI
2 years ago Place DAX Commands and Tips
566Views
0likes
1Comment
Get the value for the previous non blank date
Hi everybody, I'm trying to calculate a Day On Day Change for a set of stocks. The thing is, when it comes to getting the previous day value, there are sometimes where Dax returns me a blank value since there's a weekend in between. I guess this is because my formula has flaws... I'd like just to have the previous day value as it happens when it's labour day. Formula and tables are: Latest ULSD 10ppm MED (€/l) = CALCULATE ( AVERAGE('ULSD 10ppm CIF MED'[Litres EUR Prevat]), FILTER ('ULSD 10ppm CIF MED', 'ULSD 10ppm CIF MED'[Date] = CALCULATE ( LASTNONBLANK ( 'ULSD 10ppm CIF MED'[Date], 1 ), FILTER ( 'ULSD 10ppm CIF MED', 'ULSD 10ppm CIF MED'[Date] <= LASTDATE( 'ULSD 10ppm CIF MED'[Date]))))) PR ULSD 10ppm MED CIF Cargoes (€/l) = IF(ISBLANK([Latest ULSD 10ppm MED (€/l)]), [Latest ULSD 10ppm MED (€/l)], CALCULATE ( AVERAGE('ULSD 10ppm CIF MED'[Litres EUR Prevat]), PREVIOUSDAY('CALENDAR'[Date]))) DoD Change ULSD 10ppm MED CIF Cargoes (€/l) = Var Division = DIVIDE([Latest ULSD 10ppm MED (€/l)] - [PR ULSD 10ppm MED CIF Cargoes (€/l)], [PR ULSD 10ppm MED CIF Cargoes (€/l)]) Return Division Expected Results are: Date Litres EUR Prevat (Current) Prev. Value DoD 02/06/2023 1.0618 1.0542 0.0072 01/06/2023 1.0542 1.0411 0.0126 31/05/2023 1.0411 1.0453 -0.0040 30/05/2023 1.0453 1..0591 -0.0130 29/05/2023 1.0591 1.0598 -0.0006 26/05/2023 1.0598 1.0508 0.0086 Appreciate any help.
Solved
Alezy
3 years ago Place DAX Commands and Tips
1.4KViews
0likes
2Comments
Show Previous Values Per Day
I have the following table loaded into PBI. I can get the previous count per day using `PreviousDay` but when I want to add in another column I have trouble understanding how. Date Count RequestBucket 11/2/2022 10 Red 11/2/2022 20,000 Green 11/1/2022 3 Red 11/1/2022 25,000 Green How can I capture the previous count per date and RequestBucket? New table: Date PreviousCount Count RequestBucket 11/2/2022 3 10 Red 11/2/2022 25,000 20,000 Green 11/1/2022 Null 3 Red 11/1/2022 Null 25,000 Green
Solved
SirBI
3 years ago Place DAX Commands and Tips
565Views
0likes
1Comment
Incorrect Subtotal
Hi I have a DAX for custom measure with the formula of Prev Day User Asset USD Latest Rate = CALCULATE(sum('user daily asset'[amount_usd_latest_rate]),PREVIOUSDAY(Dates[Date])) The DAX will give result like below. Where the prev day value of each day is correct, but on the subtotal of the month, its showing the previous day record of the first date instead of the SUM of all the prev day value. How can this be fixed? Thanks
Solved
ikhwan_tokenomy
3 years ago Place DAX Commands and Tips
2.1KViews
0likes
4Comments