Forum Discussion

bherring1979's avatar
bherring1979
Frequent Visitor
10 years ago
Solved

Calculating Data by Date Range in Power BI

I'm very new to Power BI, but I do have a development background. I am trying to learn how to create a profitability report for our organiztion. This report needs to be dynamic enough to look back at...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I may be completely off target but why not use the measures you already have and use your months as the axis or as rows to show the relevant data by specific month. Using a date calendar you could also show by calendar quarter. In other words, let your measures do the simple part of the equation (the math) and have PowerBI divide it up into periods in the visualizations using slicers and filters.

    Of course it has been a long week and I may be completely misunderstanding the question.

     

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

Without knowing the exact formula or the granularity of the data is difficult to help you better, but you can try to divide the Total Income by a dynamic number of months like  DIVIDE(Total Profit ; COUNTROWS(VALUES(Dates[Month]))) or something similar.

ashokkumar's avatar
ashokkumar
New Member
9 years ago

Hi, i am learner of power Bi  how to calculate profit using dax expression