Forum Discussion
Dax Measure with Calendar code
Hi All, PBI Newbie here! Need help on how to formulate the dax code on how to measure with coded calendar in the Table data from Jan 1 2021 to Aug 15, 2023. Thank you for the help Case: Dash...
jhoyabel , you can use datesytd or totalytd for that
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
How do you make data output dynamic once the filter date is set to a specific end date
iex. Filter date - 2023 until Aug 15
Outcome - 6
