Forum Discussion
Splitting Values into Quarters Based on a % - '1' error
I have yearly volumes as column headings and want to split to quarters based on a % value in another table.
The problem is the '1' value is lost - as the quarterly % split is never above 50%.
Is there a function that would allow me to asign to a specific quarter IF the value is 1?
Thanks!
James
2 Replies
- Omid_Motamedise
Super User
The question is not clear for me, can you provided your question data as table here and also provide your desired result as table?
Hi JamesDorling ,
You might consider posting sample data here that fully covers your question and shows your expected output.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
