Forum Discussion
Resolver IIIHelp with Dax
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
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.
5 Replies
- Jihwan_Kim
Super User
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
ChandrashekarHello,
I do not want give relationship. is it possible without relation by using DAX.
DAX as follows1. Selected_month = SELECTEDVALUE('Calendar'[MonthYear]) ' stores selected month2. 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-24I need dax for both selected month & Selected_Month_Prev1Sample File: PBIX
Regards,
Chandrashekar B
- Jihwan_Kim
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.