Forum Discussion
RSD
Helper II
Helper IIDAX
Hi Team, I Would like to show "106.8%" in Card , But unable to write DAX. It should be Avg Forecast Accuracy of Previous months .(March) Note: All columns are in list are Measures Except ...
Hi RSD ,
We can use the following measure to meet your requirement.
Show Last Month = CALCULATE ( [FYTD Avg Accuracy], 'Table'[date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 ), 'Table'[date] < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) )If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
