Forum Discussion
Help needed with a DAX Formula
The "problem" is as following: I want a new column that calculates with several statements, for instance: (Started with the saving of data from 01-2020 thats why I start there) From Jan-2020 t/m ...
amitchandak
Super User
Super UserSebasB , is your date table working. If not
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
for the above one you can try
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"10/31"))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit,
Yeah this one is working, works fine with all views. Uploaded data.
Did not yet add all data, will be some data from ServiceNow and Azure added but those are not needed for this part.
