QTD & YTD doesn't work

[sps_rawat]

Hello, I have simple two table i.e. FactTable and Calendar. Calendar table is marked as date table too.

I am try to calculate QTD and YTD total but formula simply doesn't work. Any help please? I am new in PowerBI

.

Trxn:=sum([Amount])

Actual Trxn QTD:=CALCULATE([Trxn],DATESQTD(Calendar[Date]))

Actual Trxn YTD:=CALCULATE([Trxn],DATESYTD(Calendar[Date]))

Kind regards, Satyapal

[v-haibl-msft]

@sps_rawat

Please try it in Apr 2017 version of Power BI Desktop. You need to create relationship between Calendar and FactTable with Date key. The measure you provided should work in Table visual as below.
Please refer to attached PBIX file.

Best Regards,
Herbert

[sps_rawat · Accepted solution]

Hello,

Thank you for the answer.

I don't know what was the exact problem but I simply remove the relationship first and then re build relationship and it worked.

Thank you

[dearwatson]

This could be related to your version of Excel... I seem to remember these functions only working in later versions?

What Excel are you using? I note you have the "backwards" filter arrows so it must be 2013 or less?

Cheers