Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
Solved

Sum data based on date range

Hi,     I have a date column in my table and a sales column. The dummy data is as follows:   Date          Sales   10/1/2016    500 9/1/2016      200 8/1/2016      600 1/1/2017    100    No...
Need Help
Show and Tell
Tips and Tricks
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi siddhantk989,

     

    It's same result, I just change connection and field name from Order Date-> Date to fit with your file with my column fields. 

     

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi siddhantk989,

 

It's same result, I just change connection and field name from Order Date-> Date to fit with your file with my column fields. 

 

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

Hi tringuyenminh92

 

I know the solution is perfectly fine and it is working with most of my code. but I just encountered 1 scenarion that If I have sales as 0 for Jan 2017 the fiscal year code for me is not working in this scenario. Please find the attched sample ata at the below link and kindly let me know where I am hoing wrong:

 

https://1drv.ms/x/s!AoXl4WEaulxtaUSydM8pD6I5vw0

 

Sorry for disturbing you again and agin but I am completely new to DAX coding.

 

Thanks in Advance.

 

Thanks,

Siddhant