topic Re: Previous Month and Current Month same period --- with filter in DAX Commands and Tips

Previous Month and Current Month same period --- with filter

Siops — Fri, 30 Aug 2024 18:11:34 GMT

Hello! I tried several calculations from this forum and also watched some videos regarding the current and previous month measurement but I am getting a different result when I tried those formula on my end.

These are my measurements -

MTD =

CALCULATE(

SUM(Sample[Case])

, DATESMTD(Sample[Date])

)

Last MTD =

CALCULATE(

'Sample'[MTD]

, DATEADD('Sample'[Date], -1, MONTH)

)

I got a different results based on one of the answer here and also from one of the video.

1. MTD field should be cumulative. I am getting the same value of my 'Case' field

2. Last MTD field should show the previous value. For example, under January 2, it should show 56 cases. But my whole Last MTD field is showing blank except that it is showing a value under Total. It is a SUM of all months minus the latest month.

3. Once I click a Month Filter/Slicer, the Last MTD will show as "(Blank)"

Re: Previous Month and Current Month same period --- with filter

lbendlin — Fri, 30 Aug 2024 20:13:57 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Previous Month and Current Month same period --- with filter

Siops — Sat, 31 Aug 2024 07:44:19 GMT

Hi, this is my sample data

https://drive.google.com/file/d/13OQVLW4fRwaSJ2d_FFLMj-g_wV98BgXb/view?usp=drive_link

This is the output that i want to achieve

https://youtu.be/Gw0t4TKkzE4?si=2Bd4BdI9_Ir-y7QL

based on the video, the MTD will show cumulative numbers but I am getting the same value of total cases.

the PREV Month on the video will show numbers per day based on the previous month's data, but it is showing blank on my end, but it has a value under Total which is the sum of all months minus the latest month
also, when i click a slicer filter for months, the PREV will become blank

Re: Previous Month and Current Month same period --- with filter

lbendlin — Sat, 31 Aug 2024 17:24:38 GMT

You need to use a Dates table for time intelligence functions.