I want to measure MTD and PM MTD

hctrgrc — Tue, 04 Jun 2024 17:41:05 GMT

Hello! I'm still relatively new to Time Intelligence Measures. Ultimately I want to measure MTD-PM (Month to Date of Previous Month) but it seems I can't even calculate MTD correctly.

In the picture, you can see on top the total volume of the month and down on each side is a different approach of MTD (that I remember seeing, one might not be used correctly in this scenario). Firstly, I would expect to see the bar charts in an increasing pattern. If MTD is the cumulative function then I would expect day 2 to be the sum of day 1 + 2 and so on but I'm not seeing this effect.

These are my DAX codes (My Tons volume is a Measure itself, it is not the SUM of a table column):

Using DATESMTD

DATESMTD_Tons = CALCULATE(Medidas[Toneladas], DATESMTD(Fecha[DocDate]))

Using TOTALMTD

TOTALMTD_Tons = TOTALMTD(Medidas[Toneladas],Fecha[DocDate])

I also have a Day filter on the top right side of the image where I put this DAX codes to the test. I filter through each day but I don't see the summing effect. For instance check day 6 and day 7:

I would expect by day 7 to see 104+43 = 147 as my Tons volume.

These are my main relevant model relationships. "Medidas" stands for Measures in Spanish. I'm not sure if somehow my Measures must be connected to my Date table (Fehca in Spanish)

-.-.-.-.

Once I get this down I would then like to simply calculate with DATEADD (I would guess) the Previous Month.

Hope I'm being clear enough 😄

Thank you very much!

Re: I want to measure MTD and PM MTD

Greg_Deckler — Tue, 04 Jun 2024 17:49:58 GMT

hctrgrc You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

topic I want to measure MTD and PM MTD in DAX Commands and Tips

I want to measure MTD and PM MTD

Re: I want to measure MTD and PM MTD