cancel
Showing results for
Did you mean:
Helper I

## Current MTD Last Year is empty but showing as grand total

Hi All,

Please see the attached pic. I have 4 columns. Charges MTD , Chargers MTD Last Year, Year and Month.

As you see, the Charges MTD Last Year is empty , but showing as Subtotal.

DAX i used

Charges MTD = CALCULATE(SUM('Transactions (2)'[Set 01 Charge Amount]),MONTH('Transactions (2)'[Charge Create Date.Date])=MONTH(TODAY()))
Charges MTD Last Year =
CALCULATE (
TOTALMTD ( SUM ( 'Transactions (2)'[Set 01 Charge Amount] ), 'Transactions (2)'[Charge Create Date.Date] ),
SAMEPERIODLASTYEAR ( 'Transactions (2)'[Charge Create Date.Date] )
)
Thanks
3 REPLIES 3
Super User

@amybirc77 no you are not using date dimension, your date is referring to the same table which is Transactions (2) table.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

@amybirc77 the fundamental problem is how you are calculating these values, when you are working time intelligence, it is a best practice to use calendar dimension in your model and make use of time intelligence DAX functions. Check out my youtube playlist on time intelligence and the importance of calendar dimension, once you check this out, and update your message, it should work.https://youtube.com/playlist?list=PLiYSIjh4cEx2FkuGkngYruS0wm8MYFsoi

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper I

@parry2k thanks, but I have a date heirarchy as you see in the screen shot.Our datawarehouse has a date dimension and that Is what I use.

Thanks

Announcements

#### CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors