topic Re: Not able to create Previous YTD measure in DAX Commands and Tips

Not able to create Previous YTD measure

Radhe — Wed, 23 Aug 2023 20:26:51 GMT

Hi,

I am new to PowerBI DAX and I working on chart for comparing YTD and prevoius year YTD, however, I am not able to create previous YTD measure as it shows just one single value in Card but I am not able to make it work with chart.

Here are my measures for YTD and previous Year YTD.

YTD = TOTALYTD([Total Sales], 'Date'[Date])

Previous YTD = CALCULATE([Sales YTD], SAMEPERIODLASTYEAR(INTERSECT (

VALUES ( 'Date'[Date] ),

DATESBETWEEN ( 'Date'[Date], BLANK (), DATE(2019,12,31 )

))))

Can someone help with this?

Re: Not able to create Previous YTD measure

some_bih — Thu, 24 Aug 2023 06:09:16 GMT

Hi Radhe try

Previous YTD=

CALCULATE (

[Total Sales],

PARALLELPERIOD ( 'Date'[Date], -1, YEAR )

)

For Card visual I am not sure what you need. Try measure and let what else is needed / is it working.

Did I answer your question? Kudos appreciated / accept solution!

Re: Not able to create Previous YTD measure

Radhe — Fri, 25 Aug 2023 20:22:33 GMT

Hi some_bih ,

The formula you gave did not work. The previous YTD over years is empty in table over the years but I can see one value in the card visual. I want the previous YTD to compare with YTD over the years. I have attached the Visual and settings. Hope this helps to understand my problem in more detail.

Let me know if you need more information.

The total sales itself is a measure.

Total Sales = SUM(Sales[Sales Amount])

Re: Not able to create Previous YTD measure

some_bih — Fri, 25 Aug 2023 20:55:28 GMT

Hi Radhe as you already crrated YTD measure try

Previous YTD =
CALCULATE(
[YTD],
SAMEPERIODLASTYEAR('Date'[Date])
)