Current month/Year/Qtr

[Anonymous]

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

[v-yanjiang-msft]

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

[Anonymous · Accepted solution]

I have the sample data from that month only