To show Prior Year values for only Current Fiscal Year

[Saloni_Gupta]

Hi All,

I have created a Dax logic to calculate prior year values as below :
FY Prior Year Values=

var maxDate_PY = CALCULATE(Max('MP'[Date]),DATEADD(('MP'[Date]),-1,YEAR))

RETURN

 CALCULATE(SUM(MP[PTD_Actual]),

 'MP'[Date] = maxDate_PY)

It gives me correct result for all the Dates. Now, I just want to show these values for Current FY Year, how can I do that (like FY Values in the screenshot)?
I simply used Current Year flag for FY values but Prior values logic does not work with Current year flag

FY Values= CALCULATE(SUM('MP'[PTD_Actual])

    ,'Month Table'[Current FY Flag] = "Y"

Can you please help filtering these values for only Current FY (in DAX) ?

Thanks in Advance!

[v-jianpeng-msft]

Thanks solutions from @Ashish_Mathur and @quantumudit , your solutions is great!

Hi, @Saloni_Gupta 

You can put your FY Values measure into a Filter pane visual filter and set it to non-null. I created a sample as follows:

I have two measures, value_1 and value_2, and there are some empty items in the value_1.:

I put the value_1 measure in the Filter pane next to it and set it to "is not blank"

The results are shown in the figure below:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[Ashish_Mathur]

Hi,

Try this approach

1. Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number
2. Create a relationship (Many to One and single) from the Date column of your Data Table to the Date column of the Calendar Table
3. to your matrix visual, drag Month name to the Row labels and year to the column labels
4. Write this measure

Total = sum(Data[Amount])

Hope this helps. 

[quantumudit · Accepted solution]

Maybe you can try this:

FY Prior Year Values (New) = IF(ISBLANK([FY_Values]), BLANK(), [FY Prior Year Values])

Let me know if it solves your issue.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree