Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Upali63
Helper II
Helper II

Need 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

Upali63_0-1695974795902.png

 

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

 

Upali63_1-1695975463973.png

You help is very much aprreciated please.

1 ACCEPTED SOLUTION

Hi,

PBI file attached.

Ashish_Mathur_0-1696139446998.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

15 REPLIES 15
anilkapkoti
Helper II
Helper II

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

Hi Anil

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

Upali63_0-1696065032801.png

 

Upali63
Helper II
Helper II

Dear Members,

 

Kindly request to help me with my issue

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

That takes me to a sign-in page.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Access Denied message.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

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

Hi,

PBI file attached.

Ashish_Mathur_0-1696139446998.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish

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

Thanks a lot

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Upali63
Helper II
Helper II

Your help to solve my issue is greatly appreciated

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors