Forum Discussion
Time Measure Issue (Chart x Table)
Hi, I do have a table with "YTD_values", and i use the following measure to get the "Period_Values" per month with a date condition on january (fiscal year), thats work's great on line chart bu...
December = 1 (YTD from december ) - 0 (From november) = 1
January = 4 (YTD from january) = 4
February = 3 (YTD on february) - 4 (from january) = -1
Dec+jan+Feb = 4
The code shared didnt work:
Trying to be more clear, i want Month values from a YTD table that reset in 31/december, knowing that, i need to especify a condition on january.
I need a measure that that show corrects sum of results on my table with/without "date filter"
I want this "Month_Value" column/measure so i could get total "Month_Value" of "Type A" from "dec/19 to fev/20" = 4
| Type | Date | YTD_Value | Month_Value |
| A | 01/11/2019 | 0 | 0 |
| B | 01/11/2019 | 0 | 0 |
| A | 01/12/2019 | 1 | 1 |
| B | 01/12/2019 | 1 | 1 |
| A | 01/01/2020 | 4 | 4 |
| B | 01/01/2020 | 2 | 2 |
| A | 01/02/2020 | 3 | -1 |
| B | 01/02/2020 | 3 | 1 |
Anyone?