Measure OK on Table, but can't make it work on a Card

[Sab]

Hello,

This may be simple, but I am stuck, so please help!

My data is stored as YTD data, so for each quarter, the data are added with the existing values of previous quarters (FY ends in March 31). 

To calculate the actual values for each quarter, I have to subtract value of actual quarter, with the value from the previous quarter (in the first quarter this is not needed, as with the new FY, the values reset).

I've created this measure which works when put in Table (it has right context with FY and Fiscal Quarter columns), but it doesn't work when I put it in a card visual, EVEN if I use the slicer to select different quarters! So if no quarter is selected on slicer, it shows the total (as in the screenshot) and when the quarter is selected, it show YTD value and not the subtracted value as I need it 😞

Thanks!

[Sab]

@amitchandak was able to fix it. Thank you!

[Sab]

Its confidentional 😐 I can't share it!

So the date table is there, the calcualtions are based on FY starting on April 1. Everything can be seen in the screenshot I think, I just need to extract the FQTD value from the table and put it in the card 😔  (for the selected value in the slicer of course)

[amitchandak · Accepted solution]

@Sab , have you tried datesqtd with date table ? As April is start month of QTr this should work . Qtr No should be there in date table based on FY

example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[Sab]

Didn't help 😞

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.