Forum Discussion
Post ProdigyYTD Measure
Hi,
I have an issue with the following measure that works ok except for the month 9 (September).
=CALCULATE([Rev Master],DATESBETWEEN(Period[[Month]]],IF(MONTH(TODAY())>=9,DATE(YEAR(TODAY()),9,1),DATE(YEAR(TODAY())-1,9,1)),IF(MONTH(TODAY())=9,TODAY(),EDATE(TODAY(),-1))))
What changes shoud I make to fix this ?
1. The code seems to be incorrect, DATESBETWEEN's first argument should contain Date column, that column doesn't seem like a Date column in your code
2. The way of asking the question is wrong, don't just paste code and expect others to answer, always provide the data and the screenshot of issue that you are facing.
1 Reply
- AntrikshSharma
Community Champion
1. The code seems to be incorrect, DATESBETWEEN's first argument should contain Date column, that column doesn't seem like a Date column in your code
2. The way of asking the question is wrong, don't just paste code and expect others to answer, always provide the data and the screenshot of issue that you are facing.