DAX

[RSD]

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 Year and Month.

Regards,

Rupesh Dhage

[v-zhenbw-msft · Accepted solution]

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.

[RSD]

Hey @v-zhenbw-msft ,

It contains time intelligence Calculations of FYTD(Finacial Year to date) and hence it was behaving weird.Even though somehow I managed to get same functionality , but i like your solution. Thanks for your help .Much Appreciated!!.

Regards,

RSD

[parry2k]

@RSD there are many ways to achieve this but it is important to what DAX expression is used in  FYTD

[RSD]

Hey @parry2k ,

Please find the DAX calculations for FYTD.

[amitchandak]

@RSD , Make sure you use date table for this

YTD QTY forced=
var _max = maxx('Shipmenr + forecast DT',[date].date) //To Stop ytd at max date
return
calculate([shipment Accuracy],DATESYTD('Date'[Date]),'Date'[Date]<=_max)

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/