Not able to create Previous YTD measure

[Radhe]

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? 

[some_bih]

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!

[Radhe]

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])

[some_bih]

Hi @Radhe as you already crrated YTD measure try

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