Hi Fernan, thank you very much for this good and concise video on this topic. The If-Statement that you used in the %-Change Dax Measure only uses one Ampersand (&), i.e. [Total Sales] & [Total Sales LY] , I re-created your formula and I had to use double ampersand to get the formula working. How come your formula with just one ampersand works as well? It does work on your side, I can see it. Is there a hidden setting that I could check or uncheck so that I only have to use one Ampersand (&) instead of two?
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.
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.
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, thank you very much for this good and concise video on this topic. The If-Statement that you used in the %-Change Dax Measure only uses one Ampersand (&), i.e. [Total Sales] & [Total Sales LY] , I re-created your formula and I had to use double ampersand to get the formula working. How come your formula with just one ampersand works as well? It does work on your side, I can see it. Is there a hidden setting that I could check or uncheck so that I only have to use one Ampersand (&) instead of two?
Hi Fernan! thanks for this video. my only question is how do you handle leap year in same period last year calculaitons? 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.
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.
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.
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
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 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 few questions but before that I will test and then give you comments
Alright
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
..