Forum Discussion
Helper IITime Intelligence YTD and Previous year calculation.
Hi Experts,
I am creating a power bi sales dashboard with KPI's showing previous year sales, year to date sales and Variance indicating positive or negative. I will like the KPI to be time intelligence to only use same period as last year. For instance if the year to date KPI is showing $50,000 then last year sales should only calculate up to October 22 of last year.
Any dax function that can help with this?
Thank you
5 Replies
- goncalogeraldes
Super User
Hello there Nanakwame ! You can either use the SAMEPERIODLASTYEAR() or the PARALLELPERIOD() with the same formulas that are your current measures. You can check the following documentation on these two formulas:
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
NanakwameThis is what have for sales PYTD
SalesPYTD = CALCULATE([SalesYTD],SAMEPERIODLASTYEAR('Date'[Date]))It doesnt work for this formula- goncalogeraldes
Nanakwame I'll give you a few examples:
SalesPYTD = CALCULATE([SalesYTD],SAMEPERIODLASTYEAR('Date'[Date].[Date])) SalesPYTD = CALCULATE([SalesYTD],DATEADD('Date'[Date], -1, year)) or alternatively: SalesPY = CALCULATE([Sales], SAMEPERIODLASTYEAR('Date'[Date].[Date])) SalesPYTD = TOTALYTD([SalesPY], 'Date'[Date].[Date])Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
- Greg_Deckler
Community Champion
Nanakwame You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008If you have a custom fiscal calendar TI functions are useless.
