Help with Dax

[Chandrashekar]

Hello,

Can you please help me with Dax as not getting value for previous month.

I need this for some purpose as am aware to get this creating relationship.

Sample File: PBIX 

Regards,

Chandrashekar B

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

[Chandrashekar]

Hello,

I do not want give relationship. is it possible without relation by using DAX.

DAX as follows

1. Selected_month = SELECTEDVALUE('Calendar'[MonthYear]) ' stores selected month

2. Selected_Month_Prev1 = date(year([Selected_Month]),Month([Selected_Month])-1,1) 'stores selected motnh -1 .for ex: if selected month is Apr-24 it stores Mar-24

I need dax for both selected month &  Selected_Month_Prev1

Sample File: PBIX 

Regards,

Chandrashekar B

[Jihwan_Kim · Accepted solution]

Sorry and I do not understand what do you mean by, [I do not want give relationship].

Your file already had a relationship,

my first suggestion was changing the relationship.

But, I assume deleting the relationship. Am I correct?
Please correct me if I am wrong.

[Chandrashekar]

Thank you. It is working perfectly.

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Thank you. Let me check and get back you on it.

Regards,

Chandrashekar B