Forum Discussion
Split Half Years Into Quarters
Hi, I am a biginner user of Power BI and I am not even sure if this is the right place to ask this question. But the problem is as shown in the photo. The data is in half years (ofcour...
Take a look at my answer to this similar question earlier today:
https://community.powerbi.com/t5/Power-Query/Repeat-quarterly-results-for-every-month/m-p/2252280
That same sort of logic should work except for the Tons part. How are you transforming 4000 into 44.44 and 43.95?