Calculate previous month total when dates are multiple

[Anonymous]

Hi, 

I am calculating total of previous month with condition. I am getting error as below

[aj1973]

Hi @Anonymous 

You need a Calendar table to be able to use Time intelligence functions. your current date column contains duplicate values.

[Anonymous]

@aj1973 ,

How to solve this ?

I need it in a measure 

[aj1973]

I just told you, You need a Calendar table in your model. Do you have a Calendar table in your model?

Can you screen shot your model?

[Anonymous]

No Calendar table.

[aj1973]

Indeed,

Now Add a calendar table and join it to RADsNew at Created column

[Anonymous]

@aj1973 

How to write a measure combing 2 tables ?

[aj1973]

"combing 2 tables" What do you mean?

Can you share your Pibx file? It would be easier and faster.

[Anonymous]

@aj1973 

Now please tell me DAX to calculate total number of RADs from previous month

[aj1973 · Accepted solution]

Previous Month = CALCULATE(COUNT(RADsNow[Number]), PREVIOUSMONTH('Created Date' [Date]))

[Anonymous]

@aj1973 

The value should be 5 but I am getting blank(0).

[aj1973]

Would you be able to share your file?

Can't tell where is your new issue now.

[Anonymous]

@aj1973 

Not sure how to share the file, please do let me know, I am ready to do it 

[aj1973]

Use Google drive, Onedrive, Dropbox...

You can send me the link in private if you want.

[Anonymous]

@aj1973 ,

anyupdate ?

[aj1973]

just sent you a private message

[Anonymous]

@aj1973 

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

Here is the file