undefined

[Haripinnoju]

Hi, I need a dax query which can show the data of the spend(usd) based on the current months/year, i.e., as now it is H1 of the year, it should the spend data of the H2 2022+ 2023 YTD, When it is after June 30,2023 as it enters into H2 of the 2023 year, then it should only the 2023 YTD spend Data into the dashboard. Similarly it should follow for all the upcoming years/months data.

[ryan_mayu · Accepted solution]

@Haripinnoju 

maybe you can try this

Measure = if(month(today())>6,sumx(FILTER('Table','Table'[date]>=date(year(today()),1,1)),'Table'[value]),sumx(FILTER('Table','Table'[date]>=date(year(today())-1,7,1)),'Table'[value]))

[Haripinnoju]

Thank you 

[ryan_mayu]

you are welcome