Forum Discussion
Calculating Data by Date Range in Power BI
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.
Community ChampionI 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.
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
Hi kcantor ,
The data is not matching until and unless the slicer end date is current date. But I need slicer end date as required and the data should match .
Can you please help on thisThanks in advance.
