Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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]))
Proud to be a Super User!
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]))
Proud to be a Super User!
Thank you
you are welcome
Proud to be a Super User!
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |