Forum Discussion

PowerBi2bPro's avatar
PowerBi2bPro
Helper I
2 years ago

Help Needed - Troubleshooting Blank Column Values

Hi Everyone,   I am using this Function:   Prv_Qtr_Assets = CALCULATE(sum ('Income Statement $'[Average Assets]), DATEADD('Income$MasterDate'[Date].[Date],-1,QUARTER))   My goal was to create ...
lbendlin's avatar
lbendlin
Super User
2 years ago

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

  • PowerBi2bPro's avatar
    PowerBi2bPro
    Helper I
    2 years ago

    Okay so here is the Date Column

     
    Year
    Sunday, December 31, 2023
    Saturday, September 30, 2023
    Friday, June 30, 2023
    Friday, March 31, 2023
    Saturday, December 31, 2022
    Friday, September 30, 2022
    Thursday, June 30, 2022
    Thursday, March 31, 2022
    Friday, December 31, 2021
    Thursday, September 30, 2021
    Wednesday, June 30, 2021
    Wednesday, March 31, 2021
    Thursday, December 31, 2020
    Wednesday, September 30, 2020
    Tuesday, June 30, 2020
    Tuesday, March 31, 2020
    Tuesday, December 31, 2019
    Monday, September 30, 2019
    Sunday, June 30, 2019
    Sunday, March 31, 2019
    Monday, December 31, 2018
    Sunday, September 30, 2018
    Saturday, June 30, 2018
    Saturday, March 31, 2018
    Sunday, December 31, 2017
    Saturday, September 30, 2017
    Friday, June 30, 2017
    Friday, March 31, 2017
    Saturday, December 31, 2016
    Friday, September 30, 2016
    Thursday, June 30, 2016
    Thursday, March 31, 2016
    Thursday, December 31, 2015
    Wednesday, September 30, 2015
    Tuesday, June 30, 2015
    Tuesday, March 31, 2015
    Wednesday, December 31, 2014
    Tuesday, September 30, 2014
    Monday, June 30, 2014
    Monday, March 31, 2014

     

     

    And the Assets Values are

    Total Assets
    27408122
    26509769
    25332322
    26271688
    22286667
    25040832
    20040832
    26939596
    24435452
    22357669
    21180529
    23543250
    24505919
    26548231
    22130804
    22136679
    20949843
    20785811
    19597814
    18325954
    21515747
    20020337
    20148203
    20624152
    19088009
    22220718
    18857304
    16690154
    17796706
    18882873
    18850505
    19996543
    16654922
    14467134
    11169202
    13336748
    14405544
    15503513
    15066288
    14033294
     

     

    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. 

     

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Your formula seems to be fine (minus the unnecessary auto date/time - you forgot to mark the Dates table as such)

       

       

      • PowerBi2bPro's avatar
        PowerBi2bPro
        Helper I
        2 years ago

        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.