cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Time 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 5
Super User

@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-TIT...

If you have a custom fiscal calendar TI functions are useless.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
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

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

Helper II

This is what  have for sales PYTD

SalesPYTD = CALCULATE([SalesYTD],SAMEPERIODLASTYEAR('Date'[Date]))
It doesnt work for this formula
Super User

@Nanakwame I'll give you a few examples:

``````SalesPYTD = CALCULATE([SalesYTD],SAMEPERIODLASTYEAR('Date'[Date].[Date]))

or alternatively:

SalesPY = CALCULATE([Sales], SAMEPERIODLASTYEAR('Date'[Date].[Date]))
SalesPYTD = TOTALYTD([SalesPY], 'Date'[Date].[Date])``````

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

Helper II

I have the same dax function but it appears to be showing the full year previous sales instead of the same period.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors