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 Baskar,

 

As my guessing, I missed one step in my guideline that create relationship between Dates and Fact table:

 

 

 

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

tringuyenminh92 I have created relationship between the 2 tables but i dont know wh I am not getting the correct result for my data. Can you please try with the data that I have provided to you once

  • 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

       

      Thanks a lot for your help. I think the problem was with the date format. The solution is working perfectly fine now.

    • 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