Forum Discussion
Dynamic sumx () specific vales from a table
For my particular circumstance, I decided to add an extra column to the query by adding a line of multiple CASE WHEN functions to the sql query.
The idea does not appear to be a bad one.
I can do it in the backstage using sql or in the power query editor.
The disadvantage is that this report will require human intervention every time the quarter changes...because the fltr_Qtr for either of the two possibilities will be manual.
perezco Could you add a column for 'Quarter' that filters which conditions should be used each quarter?
Your intervention has made it much easier for me to see things in a more straightforward manner.😁
yes. I have the 'Quarter' column part of this fact table. 👍perezco Glad the fog is clearing and it's getting easier - what questions do you still have outstanding? Or can we mark this post as solved?
Feel free to write up a summary of what you did and mark your own post as the solution if that makes the most sense. 🙂
For my particular circumstance, I decided to add an extra column to the query by adding a line of multiple CASE WHEN functions to the sql query.