Cy purchase amount not correctly showing

[rajasekaro]

hi team ,
i have calculate purchese amount and cy purchese amount 
cy (current year) purchase amount not correct
1.Purchase Bill Amount =
CALCULATE(SUM('PURCHASE ORDER BILL'[GSTASSVALUE]),'PURCHASE ORDER BILL'[OTHER]="PURCHASE BILL")/SELECTEDVALUE(DISPLAYAMOUNT[DIVFACT])

2.CY PBill Amount =

 var a = TOTALYTD([Purchase Bill Amount],'Calendar'[Date], ALL('Calendar'), "3/31")

 var b = TOTALMTD([Purchase Bill Amount],'Calendar'[Date])

RETURN

IF(HASONEFILTER('Calendar'[Month]),b,a)

how to solve this 

[v-bmanikante]

Hi @rajasekaro ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @rajasekaro ,

As we haven’t heard back from you, we will go ahead and close this ticket for now.

If you need any further assistance, please don’t hesitate to raise a new ticket, we’re always happy to help.

Our sincere apologies if there was any inconvenience caused.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @rajasekaro ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @rajasekaro ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante · Accepted solution]

Hi @rajasekaro,

Thank you for reaching out to Microsoft Fabric Community Forum.

@pankajnamekar25 Thank you for your quick response.

Could you please share a small sample of your input data (without any sensitive or confidential information), along with the expected output and a clear explanation of your requirement? This will help us understand your scenario better and provide an accurate solution. A few representative rows and a brief description of the logic or transformation you're expecting would be really helpful. 

Regards,

B Manikanteswara Reddy

[pankajnamekar25]

Hello @rajasekaro 

try this measure

CY PBill Amount =

VAR FullYTD =

    CALCULATE(

        [Purchase Bill Amount],

        DATESYTD('Calendar'[Date], "3/31")

    )

VAR MonthlyValue =

    CALCULATE([Purchase Bill Amount])

RETURN

IF(

    ISINSCOPE('Calendar'[Month]),

    MonthlyValue,

    FullYTD

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[rajasekaro]

no changes