Forum Discussion
Help Needed - Troubleshooting Blank Column Values
Your approach seems reasonable. The error may be elsewhere.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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.