Forum Discussion

bpratyusha's avatar
bpratyusha
Regular Visitor
9 months ago

Issue with SAMEPERIODLASTYEAR in Enhanced DAX Time Intelligence (Preview) Week 53 returns incorrect

We are testing the new Enhanced DAX Time Intelligence (Preview) functionality in Microsoft Power BI Desktop which allows defining custom calendars (e.g., fiscal years, 4-5-4 retail calendars) directl...
bpratyusha's avatar
bpratyusha
Regular Visitor
9 months ago

Hello v-dineshya ,

Thank you for the recommendations. I tried to implemented yet I'm blocked on the issue. 

1. LY Sales (offset) functionality dint really work. ORDERBY and MATCHBY is not recognizing DimDate table and its attributes. Also there is no DEFAULT. 

 

2. LY based on fiscal_year – 1 + same fiscal_day_in_year. The recommended measure also dint work. It returned blank values. 

The measure worked when KEEPFILTERS is removed. 

3. Cross filter direction, Single (DatePeriod --> DimDate). I changed it to Single then tested it dint work

I'm not sure how to set the Signle direction of the filter from date period to dimDate. 


I will submit an idea in the feedback channel so that the product team can work on the improvements.

Thanks,

Pratyusha

 

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
9 months ago

Hi bpratyusha ,

Thank you for the update.  Once you submitted the idea, please share the link here would be helpful for other community members who may have similar feedback. Thank you for being part of the Microsoft Fabric Community.

 

Regards,

Dinesh