Forum Discussion
Formula & Matrix visualization
Hi, The issue is stated in two parts, 1) Dividing a target on quarter basis Suppose target for the whole year is 100,000, the calculated column divides it on quartery basis, formula: Target = ...
I have got the answer with Single Cell. I think you are directlly dealing with Date avaiable in Fact table.
I suggest to create the Date Dim and relate it to Fact Table and the result will be as below. Also attaching the PBIX File for your consumption. You Cand Download the PBIX File from this Link
If you liked this solution please mention as solved and share your Kudos
Also you can watch my Videos on Power BI and Excel by clicking this Link
Regards
Vijay Perepa