Forum Discussion
Need Help
anithaMallam Very hard to say given the information provided. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
I can say that I am not exactly a fan of TI functions. 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/434008
- anithaMallam4 years agoHelper III
Hi Greg,
sample data which looks as bleow
PREVIEWthese 2 tables which i have to use to create those calculationsActual Table data
year period month unit value1 value2 total 2021 jan 1 A 0 2.18 2.18 2021 feb 2 B 4.71117 17.24189 21.95306 2021 march 3 C 0.9 0 0.9 2021 april 4 D 0 0 0 Target Data Table
year month unit ctype value1 value2 2021 1 APC SG&A 0 0 2021 1 ENN SG&A 0 0 2021 1 BCP SG&A 0 0 Regards
Anitham