Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Previous year comparison

Hello,

I am new to Qlik Sense, and I am looking for a similar function with Sameperiodlastyear in DAX (Power BI's formula language).  I'd appreciate it if you could let me know how I can tweak the expression below to achieve the similar effect as sameperiodlastyear function in DAX.  

Sum({$<[Date-Posting Date.autoCalendar.Year] = {$(=Year(Today())-1)}>}[Expense])

Thank you for your help!

0 Replies