Re: YTD of years until selected month

Anonymous · ‎11-08-2018

Dear,

I would like to get the formulae to get a KPI of the sales of the YTD until the month filtered.

I am doing a fiscal Year that goes from 1st October until 30th September.

Could you help me with the formula?

Thanks,

Kind regards,

v-shex-msft · ‎11-11-2018

Hi @Anonymous,

I'd like some sample data and expected result to help us understand your data structure and test to coding formula.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎11-20-2018

Give me some days, i will publish. Thanks

Greg_Deckler · ‎11-08-2018

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

YTD of years until selected month