i need a dax function that automatically calculates the days and divides them by a sum. example:
- start: 01.01.2020
- End: 31.12.2020
- Amount: 10 000 €
Today: 16.11.2020 days from 01.01.2020 - 16.11.2020 are 320 days
=10,000/320 (number of days to date)*45 (number of days to 31.12.2020) The number of days should be calculated automatically.
Many thanks! Nuri
Unfortunately it did not work:I have a date column. This column contains my start and end date. I want to calculate the number of days from 01.01.2020 to today with the help of a Dax-function.
I would like the number of days from 01.01.2020 to today and the number of days from today to 31.12.2020
@DagdasAlbag , not very clear, See if my attached file can help you .
Or the blog
@DagdasAlbag Hope you need a calculated measure, you need something like:
DATEDIFF( MAX(TABLE[STARTDATE]) , MAX(TABLE[EBDTDATE]),DAY)
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!