I have boolean type 'Current Year Month?' and 'Last Year Month?' line items.
To how populate them easiest way without huge amount "support rows".
Attached pic. (in the pic the green ones. Now they are manually fed)
@Miia
in the formula for last year: yearvalue(Last Year?) line item. same for the current year put the formula as Yearvalue(current year?) .
If still facing any issues let me know.
If you are updating current period of model calendar, try
YEAR(CURRENTPERIODSTART()) = YEAR(ITEM(Time)).
Thanks! - on my case YEARVALUE() worked - sometimes you just get stuck on simple stuff 🙃
Hello , you can use the YEARVALUE() function to replicate year values across months
Hi ALL, As shown in the screenshot: Columns are Locations and D2 Roles. Each Location is mapped to a Final Region Set (e.g., Toronto).The module is dimensioned by Locations and D2 Roles. I want to export this mapping to another model, but in the target module, I don’t need the D2 Roles dimension. When I try to use…
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
