Forum Discussion
Help Needed - Troubleshooting Blank Column Values
Okay so here is the Date Column
Year
And the Assets Values are
Hope this helps. I looked at how to upload the data link, and tried to follow the insert table option. Not sure if it is working. Let me know if you have any questions. Thanks again for your help.
|
Your formula seems to be fine (minus the unnecessary auto date/time - you forgot to mark the Dates table as such)
Thank you again for sharing the PIBX file. It was useful. I tried to open it and play with it to see what I get for Prv qtr and current qtr in the matrix view. Following is the outcome I got.
Above is what I am getting when putting them in to matrix. This seems still odd as the same number is displayed for both dates. Prv and Current Qtr.
Following was the setting that I used for the above matrix.
Please let me know that I am making some fundamental error, or why am I not getting different results.
Please show the expected outcome based on the sample data you provided.Thank you again. Here is a quick visual (done in PAINT) on what I am trying to get for an outcome. Not sure how to do it in Power BI.
Two Columns.
One for Current Year Asset Value and One for Previous Quarter Value
They should align in a way that at any given quarter I should be able to see both values side by side of what is current and waht was previous qtr.
My intention is to than substract current from previous to find the DELTA.
When we plot the graph, it automatically adds SUM and double counts the already aggregated raw data values. as the current quarter values are aggrgated qtr over qtr.
Hope this helps adding some more context. Thank you for your time and help.