Forum Discussion
Not able to save CTE as Table or View
- 2 years ago
I think this is now a Power BI issue rather than a Synapse issue. You will be better served posting this logic issue in the Power BI forum
I think this worked but problem is
I'm still not able to resolve what I actually I want to achieve.
This should be my end output:
But the Problem is My data is coming out of 100% and Above Output is showing DATA according to Total Hours for that month.
I hope I'm able to describe my problem statement.
Current Table :
Output Table :
I want to achieve like this so that I can create the graph as shown above.
You can ignore the Month Column of Output table as I'm okay with using Month Name & Month Number column as it is.
I hope my problem is clear.
Script I'm using I'm already mentioned above.
I think this is now a Power BI issue rather than a Synapse issue. You will be better served posting this logic issue in the Power BI forum