Forum Discussion
date add -1 year doesnt work
Hi Anonymous
Try to mark your dim date table as a date table, unfortunately, I am out if images that I can add to discussions.
So please refer to https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial
the part of (Marking a Table as the Date Table
)If it doesn't help
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Super UserHi Anonymous
Try to mark your dim date table as a date table, unfortunately, I am out if images that I can add to discussions.
So please refer to https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial
the part of (Marking a Table as the Date Table
)
If it doesn't help
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
I just had to mark the table as a date table.
Thank you very much.
- Ritaf1983
Happy to help ☺️