Thanks, Fernan cleary explained. Can you please do a presentation when target varies each year. Like sales target CY is 1.2% of total sale last last yr. And LY sales target was 1.1% of PY total sales. Can you please share PBi for such report. Thanks.
thank you for your video Fernan. However, I am still finding problem when the date slicer is added to the dashboard. I still encounter blank last year data if I filter on this year (or other specific time). How do you handle to visualize the last year sales when the date filter select only specific year? Thank you.
2 года назад
Hi, how are you? I love your videos... Btw I did the same thing for the "IF" part, but my table can't display the visual... I am still wondering about what could it be? Do you have any tips on that? Thx again, Aline.
I have been trying this SAMEPERIODLASTYEAR but Matrix visual is not showing any result , it is just showing total at the bottom of the column., that's it. Can you help me please? Plus in some cases it was only showing result in month wise data, not in year wise data.
But the date table year column should be the financial year column & the above measure is calculating the total month data but we have only 10 days of last month of current year
Hi Fernan! thanks for this video. my only question is how do you handle leap year in same period last year calculaitons? thanks
Thanks, Fernan cleary explained.
Can you please do a presentation when target varies each year. Like sales target CY is 1.2% of total sale last last yr. And LY sales target was 1.1% of PY total sales. Can you please share PBi for such report. Thanks.
Great idea, this seems really interesting, I'll try to cover it for next time!
thank you for your video Fernan.
However, I am still finding problem when the date slicer is added to the dashboard.
I still encounter blank last year data if I filter on this year (or other specific time).
How do you handle to visualize the last year sales when the date filter select only specific year?
Thank you.
Hi, how are you? I love your videos... Btw I did the same thing for the "IF" part, but my table can't display the visual... I am still wondering about what could it be? Do you have any tips on that? Thx again, Aline.
Thank you
I have few questions but before that I will test and then give you comments
Alright
How do you filter out fields which have blank previous year data without impacting the previous year data you should have in the report?
Hi How are you?
I want you to do a video on current year past 3month, 6month, 12 months and same for last Year and a delta change for both the values.
I have been trying this SAMEPERIODLASTYEAR but Matrix visual is not showing any result , it is just showing total at the bottom of the column., that's it. Can you help me please? Plus in some cases it was only showing result in month wise data, not in year wise data.
But the date table year column should be the financial year column & the above measure is calculating the total month data but we have only 10 days of last month of current year
Thaaaaaaaaaaaaaanks a lot
Do you consult?
Hi Joel, yes I do! You can reach out to me at fernan@solutionsabroad.co.uk and we can organise a quick chat
no files.. not much use
..