මචන් මෙන්න මේකයි scene එක. මම මේ microsoft forum එකකට දැම්ම එක එහෙම්ම copy paste කරලා දාන්නේ.
I'm having a data set which consists of number of emails and it's received time, date, etc. I've already created a Month and year table separately for the convenience of the visuals (These visuals are already created and functioning). (Note that all the columns in the month and year table are in text format and I'm unable to convert it to the date.)
Now I wanted to create a measure which calculates the number of emails sent in the previous month and 2 months before based on the month that the user is selecting (Slicer has been created using the above mentioned month and year tables)
I tried using all the methods (PreviousMonth, DateAdd) which are mentioned in the forum and couldn't solve this as it's giving me an error when I select this month table saying that the column chosen was in text format.
Could someone please be able to help me?
P.S - Below is an example of how my data looks like.
https://drive.google.com/file/d/1tHMVWPlpaO2pOBTe5gSKEokN2w2okB51/view?usp=drivesdk
I'm having a data set which consists of number of emails and it's received time, date, etc. I've already created a Month and year table separately for the convenience of the visuals (These visuals are already created and functioning). (Note that all the columns in the month and year table are in text format and I'm unable to convert it to the date.)
Now I wanted to create a measure which calculates the number of emails sent in the previous month and 2 months before based on the month that the user is selecting (Slicer has been created using the above mentioned month and year tables)
I tried using all the methods (PreviousMonth, DateAdd) which are mentioned in the forum and couldn't solve this as it's giving me an error when I select this month table saying that the column chosen was in text format.
Could someone please be able to help me?
P.S - Below is an example of how my data looks like.
https://drive.google.com/file/d/1tHMVWPlpaO2pOBTe5gSKEokN2w2okB51/view?usp=drivesdk
