Forum Discussion
Solved
undefined
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.
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]))
3 Replies
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]))Thank you
you are welcome