Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Please help - calculations, date ranges, and display problems

Hi all, I'm hoping someone can help me figure out how to accomplish this being new to Power BI.  I'm more a MS-SQL and Crystal Reports, Excel person so this has stumped me.   I'm including two scr...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 years ago

Hi,

 

The figures for in the Grand Total column for the "Previous Month" and "Before Previous month" measures should be blank.  These measures make sense only for a particular month (not multiple months).  In PBI desktop, i dont think you will get an answer to question 3.  In Excel, question 3 can be answered by writing CUBE functions.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Ashish,

    Thank you for replying.

     

    Is there no work around to having Power BI give me totals (as a column) to all three then?  Is this the same problem as #3?  

     

    Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      9 years ago

      Hi,

       

      I am not sure of what you mean by your first sentence.  Question 3 can be solved by writing CUBE functions in Excel.