Forum Discussion

AndresSalomon's avatar
AndresSalomon
Icon for Helper II rankHelper II
8 years ago

Need help with some Dates math

Hi all, writing some lines here to obtain your help with a problem that my limited knowledge with DAX is not able to solve.  I have this Table (a summary, of course). My Fiscal Year starts in Sept...
Need Help
AndresSalomon's avatar
AndresSalomon
Icon for Helper II rankHelper II
8 years ago

Just a clarification that may helps. 

 

The Start Date of the Asset is the first month that the Asset has an Allocation. 

 

For example, for Asset #1, the Start Date should be 11/01/2017. For Asset #2, 09/15/2017. 

So, once we are able to find it, we have to compare ONLY that date with the Overdue date, and then mark the Asset as OK or WRONG.

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi AndresSalomon,

    Actually, you compare the Overdue date and the date the Asset has allocation, where is the date(bold)? From your shared sample table, there is only Overdue date column. Please list the detailed sample table and expected result, you can create similar structure table if your data is confidential.

    Best Regards,
    Angelia

    • AndresSalomon's avatar
      AndresSalomon
      Icon for Helper II rankHelper II
      8 years ago

      Hi Angelia, thanks for replying! This problem is squeezing my brain.

       

      The biggest problem I have is actually the one you are mentioning. I don't have a column date that indicate the Asset allocation, I only have the Month column like I explicit there. And from that, as I wrote like an idea, we have to build a column that have the Asset Start Date, and then compare with the Overdue date column and mark all the lines of the Asset as OK or WRONG, so the user can filter with a slicer or something like that. 

       

      Do you understand what I mean? Please let me know if I didn't explain well. 

       

      Again, thank you very much for replying. 

       

      Kind regards,

       

      Andy.-

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi AndresSalomon,

        How to get the date column indicates to Asset allocation? What's the rules of calculation. And you said, "for example, for Asset #1, the Start Date should be 11/01/2017. For Asset #2, 09/15/2017". How did you get the 2017/11/01 and 2017/09/15?

        Best Regards,
        Angelia