Forum Discussion
Helper IINeed Modification to DAX created in my object
Hi Friends
I have with the help of community members(I am new to Power BI) has witten a Measure which is follows
But now I find that there is an error and I am not getting values in Month_TB Column against correct month. In fact I need values in the Month_TB column to be shifted down one line. Figure in Jan 22 should be shown Against Feb 22 and likewise Nov 22 Figure to be shifted to Dec 22 row. Value to be Shown agaist Jan 22 should be 15,908,408 same value shown in Amount column. Could someone please help me to modify the above Measure or give me a new Measure to achieve my requirement. Further if a calculated column could be created with same figures it is much welcome please. My expected output should look as shoen below
You help is very much aprreciated please.
Hi,
PBI file attached.
15 Replies
Hi,
Try the below dax and change as per your need.PrevMonth = VAR CurrentMonth = max('dm_tm'[cl_dt]) VAR PrevMonthStartDate =EOMONTH(CurrentMonth,-2)+1 VAR PrevMonthEndDate = EOMONTH(CurrentMonth,-1) vAR Result=CALCULATE( count('dm_tm'[cl_dt]), 'dm_tm'[cl_dt] >= PrevMonthStartDate, 'dm_tm'[cl_dt] <= PrevMonthEndDate ) RETURN Result
Upali63Hi Anil
Below is the result after applying your formula. Kindly correct me
- Upali63
Your help to solve my issue is greatly appreciated
- Upali63
Dear Members,
Kindly request to help me with my issue
- Ashish_Mathur
Super User
Hi,
Share the download link of the PBI file.
- Upali63
Thanks for Your Reply
This is my file Link Please
