topic Re: Help with Dax in DAX Commands and Tips

Help with Dax

Chandrashekar — Fri, 12 Jul 2024 09:27:54 GMT

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

Re: Help with Dax

Jihwan_Kim — Fri, 12 Jul 2024 09:46:17 GMT

Hi,

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

Re: Help with Dax

Chandrashekar — Fri, 12 Jul 2024 10:21:54 GMT

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

Re: Help with Dax

Jihwan_Kim — Fri, 12 Jul 2024 13:27:20 GMT

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.

Re: Help with Dax

Chandrashekar — Sun, 14 Jul 2024 13:19:24 GMT

Hello,

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

Regards,

Chandrashekar B

Re: Help with Dax

Chandrashekar — Mon, 15 Jul 2024 04:51:14 GMT

Thank you. It is working perfectly.

Regards,

Chandrashekar B