Need Modification to DAX created in my object

[Upali63]

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.

[Anonymous]

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

[Upali63]

Hi Anil

Below is the result after applying your formula. Kindly correct me

[Upali63]

Dear Members,

Kindly request to help me with my issue

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Upali63]

Thanks for Your Reply

This is my file Link Please

https://app.powerbi.com/groups/me/reports/858ab4a1-a593-4227-b1c0-30c953a7e064/ReportSection?experie...

[Ashish_Mathur]

Hi,

That takes me to a sign-in page.

[Upali63]

Hi Friend

I am new power bi If you can tell how to do what you want I will do it please. Sorry I am asking since I dont know about it

[Ashish_Mathur]

Upload the file to One Drive/Google Drive and share the download link here.

[Upali63]

https://drive.google.com/file/d/1C7c3jIOk_FYdHCrjzx6hicLZ0x0emsV3/view?usp=drive_link

Here is the link pls. Kindly help me

[Ashish_Mathur]

Access Denied message.

[Upali63]

Sorry Friend, I dont have much experience with . Pls try with below link

https://drive.google.com/file/d/1C7c3jIOk_FYdHCrjzx6hicLZ0x0emsV3/view?usp=sharing

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

[Upali63]

Hi Ashish

 That is briliant . I dont understant it. If you have time pls elaborate my how it works

Thanks a lot

[Ashish_Mathur]

You are welcome.

[Upali63]

Your help to solve my issue is greatly appreciated