Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper V
4 years ago

Non sequential date dimension

Hi friends,   I have a date dimension that has non sequential value : got 1 row  with date '1/1/1900' and then start with '1/1/2010' so forth until '12/31/2025' and then 1 other row with value '12/...
Need Help
Show and Tell
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, VoltesDev 

 

Do you mean that you don't want to sum 1/1/1900's data?

If yes, you can try:

CALCULATE(
           SUM('Inventory'[value]),
              FILTER(ALL (Dates[Date]),
              Dates[Date] <= MAX(Dates[Date])&&Dates[Date] > date(1900,1,1)
        )

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,
Community Support Team _ Janey