Damn - yes, they already have a slicer. I just wanted to give them control to filter the data so that it is secure when passing it onto external sa...
I worked it out and am extremely impressed with myself! This is what I did: Sales ($) PY:=CALCULATE(SUM(SP_BI_InventorySalesTransactionView[SalesVa...
sorry, fx was me trying to say "function"... The month formula is still returning a number that doesn't make sense. See the attached screenshot - ...
Yay, that worked but it isn't actually the value I am after. I want to be able to drop in a fx that shows the "SamePeriodLastYear" for another year...
Whoops, I fixed that but still getting an #ERROR It keeps adding an additional closing bracket on the end? What am I doing wrong? Sales PY:=CALC...
Sorry Mynda, I don't understand. I tried to convert to my tables and I got an #ERROR (see below for what I wrote) =CALCULATE(SUM(SP_BI_InventorySal...
Thank you Catalin, Can you define small? my area table is 221 rows (customer group is only 19) but the table I'm joining to "Customer Views" is 178...
Sorry, Catalin, I'm not a very technical person... so apologies are for my possibly silly questions. So you are saying bring the data in on the sep...
Hi Mynda, I am still finding myself a little confused about my data model. The course is saying Star is better than Snowflake... However, my dat...
Thank you Mynda, I will go and watch section 6 of the PowerPivot course.
I know I have watched a training video where there was an HR file example you had where you needed to cleanse by filling up and another one with neste...