Forum Discussion
Data Modeling-Measure between Start and End Date
Hi GhadaMehrez ,
Please update the formula of the measure [] as below and check if it can get your expected result...
| No.of months = SUMX ( Orders, DATEDIFF ( Orders[End Date], TODAY (), MONTH ) ) |
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards
Thanks a lot I created this measure but when I put the X Axis as No of Month measure the projects don't appear in the chart
Could you guide me how to attache PBIX
Hi GhadaMehrez ,
You can refer the following link to upload the file to the community. Before sharing the file, please remove the sensitive info in your file. Thank you.
How to upload PBI in Community
Best Regards
please find attached :
https://drive.google.com/file/d/1u9YQt8RMgDlkQhN1vY9UWbbRumpGKp4Y/view?usp=sharing
Hi GhadaMehrez ,
When try to open the shared file, I got the following error message... Could you please create a separate simplified report file: use Enter data method to create the quries and create visual which can be enough to illustrate your problem.
Best Regards