Forum Discussion
Current month/Year/Qtr
I have a table with 3 years of old Data and am writing a dax to get the Current month but my data is old . If i select monthly i need latest month data available in the data source and same as qtr and year.
If i write hardcode dax i can get the data but if new data update in the source its not working
2 Replies
Hi Anonymous ,
According to your code, you have a specific date, so it can't work by the data changs.
But I not very clear about your expected result, as you say you want to get the current month(2022-9), why did you specify 2022/1/8 in the formula. Would you like to explain more about it?
Best Regards,
Community Support Team _ kalyj
