Forum Discussion
ricardo_cvo
Helper I
Helper IDax Sales by Period
Good afternoon everyone, I am new to dax and need to get the sum of sales as follows: Sales from day 1 to day 30 Sales from the 31st to the 60th It's possible? Thank you
Ashish_Mathur
Super User
Super UserHi,
I will need to see your PBI file. Share the link from where i can download your file. Show the expected result there.
ricardo_cvoHelper I
Helper IHello,
Thanks for the support
Follow the link from the pbix file:
The value for the Last 60 Days field should be somewhere around 120,866.92 and is giving 308,388.11 taking into account the 31st day that is 7/07/2018 until the 60th day that is 6/08/2018.
The 30-day calculation is picking up correctly
Regards
- Ashish_Mathur
Hi,
When i click on the Downloaod button on that site, another window opens up showing some advertising. Please upload the file to some site like Google Drive/OneDrive and then share the download link here.
- ricardo_cvo