Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, could you help me?
I want to create a measure to bring from the previous month only the quantity up to the same period of the current month. As shown in the image below.
If the most current date you have is October 23rd, I want to create a measure that will bring me the total by September 23rd.
The measure I want to create is the column (TOTAL PREVIOUS MONTH PERIOD (23)) from the example.
I tried with PREVIOUSMONTH and DATEADD, but I was unsuccessful. Always brings the full date of the previous month.
Attached or dataset for example
Solved! Go to Solution.
I managed to solve. Below solution I found.
I managed to solve. Below solution I found.
do you continuous dates? The previous month, datemtd etc will work only when you have continuous dates.
Last month MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-1,MONTH)))
@amitchandak That way, I also did but he brings the month before full, I need to bring with the same period of days, in this case until the 23rd of both months.
@Tahreem24 That way, I also did but he brings the month before full, I need to bring with the same period of days, in this case until the 23rd of both months.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |