Hi Paul, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
@johnskilly
Жыл бұрын
This is superb, thank you
@EnterpriseDNA
Жыл бұрын
Hi johnskilly, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
@moshearama6612
Жыл бұрын
I do excitably what you explained and i get the massage : A date column containing duplicate dates was specified in the call to function 'DATEADD'
@EnterpriseDNA
Жыл бұрын
Hello @moshearama6612, It means that in your Date table, there're duplicate/multiple values of the same date. Following points need to be kept in mind while creating and using a date table: 1) A date table must contain full periods i.e., if a fiscal year starts on 1st Jan then calendar end date should be 31st Dec. 2) It should contain all the unique values. 3) There should be no gaps in between the dates. 4) A date table should be marked as a date table in order for DAX Time Intelligence related calculations to work properly. 5) Disable the Auto Date/Time options from the settings. Once you follow these steps, your calculations will work as expected. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZitem channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/
@moshearama6612
Жыл бұрын
@@EnterpriseDNA Thank you for your detailed answer! I will join the forum because after I failed I linked the warehouse movement table with the Calander table and then I used the formula you present but it still doesn't work even with unique values.
@ProstoSmotrim
5 ай бұрын
It is fine, but in real world data there are always blank values to compare, make update 2024)
Пікірлер: 9