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.
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.
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
![ร้อยพ่อพันแม่ - WanMai [Official MV]](http://i.ytimg.com/vi/XY2pNYASEbg/mqdefault.jpg)
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.
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!
I have few questions but before that I will test and then give you comments
Alright
Thank you
How do you filter out fields which have blank previous year data without impacting the previous year data you should have in the report?
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.
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.
Thaaaaaaaaaaaaaanks a lot
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
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
..