How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar

Options
taku.s
taku.s Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor
in Extensibility

Hello everyone.

 

I have created a custom calendar.
I have mapped Week(List) and Year(List) corresponding to Time(Days).

 

I would like to create a module that sets the start and end dates to the Week(List) and Year(List).

I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not work.

Is there any good solution for this?

 

takushimozuru_1-1626264383148.pngtakushimozuru_2-1626264426801.png

 

 

Best regards,

Tagged:

Comments

  • taku.s
    taku.s Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    Hi, @MarkWarren 

    Thank you for your reply!

     

    What kind of module (or list) is this "year mapping"?

     

    best regards,

  • taku.s
    taku.s Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    Thank you for your reply.

    I will try it as a reference!

     

    best regards,

Categories