Forum Discussion
Linking Time Intelligence to Text
Dear all, I am breaking my head over the following topic. I have a date table and use time intelligence DAX formulas to calculate quarterly sales growth. Although that is working fine, I want to ...
Hi Greg_Deckler, thanks for the links. I think I am in need of a bit more tailored solution.
To start off, I calculate the sales in last quarter using the following formula:
Sales LQ = CALCULATE([Sum of Sales], DATEADD(Customer[Date],-1,QUARTER))
As mentioned in my initial post, this formula works fine on its own, but I need it to comply with the Time Period column. How can I manage this? When looking at the links I was referred to this post but I don't see a way forward yet: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-NEXTDAY-Lone-Biker-of-the-Apocalypse/td-p/1245497.
Thanks for the support