TOTALMTD and PREVOUSMONTH

[Anonymous]

Hi , I have a data set where I have 100 row for the month July 2020 and 0 rows for Aug 2020.

I wrote DAX using TOTALMTD thinking it would show 0 as dont have any rows for Aug 2020 but it is showing 100. 

ThisMonthUserActivity =

VAR ThisMonth = TOTALMTD( Count ( 'Logs'[.id] ),(Logs[CreationDate]))

Return

COALESCE(ThisMonth,0)

I also wrote PreviousMonth measure and it is showing me 0

PrevMonthUserActivity =

VAR PrevMonth = CALCULATE( Count ( 'Logs'[id] ),PREVIOUSMONTH(Logs[CreationDate]))

Return

COALESCE(PrevMonth,0)

Why TotalMTD is taking last months data into context? And why PrevousMonth is giving me 0 while I have 100 rows of July 2020. 

Thanks for your help.

[Greg_Deckler]

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

Also, see if my Weather Intelligence the Hard Way provides a different way to achieve what you're looking for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Ashish_Mathur]

Hi,

Create a calendar table and build a relationship from the CreationDate column of the Logs table to the Date column of the Calendar Table.  In the Calendar Table, write calculated column formulas to extract Year and Month.  Create slicers for Year and Month columns from the Calendar Table.  Select year as 2020 and Month as August.  Write these measures:

FTM = Count('Logs'[.id])

Previous month = calculate([ftm],previousmonth(calendar[date]))

Hope this helps.