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.

     

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
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.

 

ameliarosaline's avatar
ameliarosaline
Frequent Visitor
9 years ago

Hello,

 

I've tried this approach of creating a measure using DATESBETWEEN Function, But this is not supported in DirectQuery mode. 

 

I'm am presently working with DirectQuery mode. Do you have any alternative method for the above question? 

 

Can someone please help me with this? 

 

Thanks