DATESYTD Not Working in Calculated Column Using Fiscal Date

[Perakun]

Hi,

I'm trying to create a calculated column for YTD value using fiscal date, but it doesn't work. I've searched on many solved similar problems, but it's still not working till now. Here is the formula I use:

CALCULATE(SUM(Compiled[Client]), DATESYTD('Date Fiscal'[Date], "04/31")

Here is the table relation (month in Compiled table is a full-set date):

table relation

And this is the result I got:

Result

Column "Sum of Client" is the data that I want to calculate, Column "Sum of Client YTD Col" is a calculated table that doesn't give my expected result, Column "Client YTD" is a measure and gives me the result I expected.

The reason I need to make YTD in calculated column instead of measure is becauese I want to make a calculated column of category based on the value of YTD, and then use that category colum as a slicer.

Can anyone help me with this please? Thank you..

[amitchandak]

@Perakun , You can not create a calculated column based on meausre

try dynamic segmentation

refer examples

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4