topic Re: DAX in DAX Commands and Tips

DAX

lucasvaranda — Thu, 09 May 2024 17:06:40 GMT

Hello everyone, I'm having a problem viewing my measurement on the card, which compares the current day to the previous day in percentages. I can see it normally on the graph and I can't see it on the card.

1: % preço = CALCULATE([Preço de venda](DATEADD(Calendario[Data].[Date], -1, DAY)))

2: var % preço = DIVIDE([Preço de venda] - [% preço], [% preço])

3: teste03 = FORMAT([var % preço], " ⬆ 0%; ⬇ 0%")

Re: DAX

Greg_Deckler — Thu, 09 May 2024 19:06:25 GMT

lucasvaranda See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
( __Current - __Previous ) * 1.

Re: DAX

Anonymous — Mon, 13 May 2024 03:18:00 GMT

Hi lucasvaranda ,

I create a table as you mentioned.

Then I create a measure and here is the DAX code.

SalePriceDifference = VAR _CurrentRowDate = MAX ( 'Table'[Date] ) VAR _PreviousRowDate = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] < _CurrentRowDate ) ) RETURN IF ( _PreviousRowDate <> BLANK (), SUM ( 'Table'[Sale price] ) - CALCULATE ( SUM ( 'Table'[Sale price] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] = _PreviousRowDate ) ) )

In Power BI Desktop, the card can only show one value, it doesn't show the values all together like a bar chart. It only show you the Total.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.