context

Hi I have this table Query1 below. I want to return the distinct count of companies where the company is in the list of companies where the filter context of campaign = a and the date is greater than the minimum date of the filter context, which in this case would be 4/1/2019 because the...

Hello, I have a Fact table like this: <tbody> Product Customer Region Date Sales </tbody> In the middle of a calculation, I would like to put that table in a variable with the following filter: <tbody> Based on...

If I use Shift+F10 for any selected FormControl/ActiveXControl/Shape, the correct context menu appears. But if I right click the object, I get a menu that reads : Move Here Copy Here Cancel Anyone know how to fix this?

Is it possible to: If [condition] then a="1',and aa="25" Can not seem to figure the context out.

Hello, Is it possible to capture a context(right click) menu event? Like to show a msgbox when you click delete on the cell context menu. I've searched everywhere online, but I can't seem to find anything. I know that I can make a custom context menu, however that is not what I want. I...

Hello everyone, I do have to face a memory error in my DAX computations. To by-pass it, I have in mind to apply some memoisation. Do you think memoisation is possible in Power BI? Here is the context: - I have to work on some data related to 1000 videos; - measure A computes an average of the...

Hello all, Is there any way to make the font bold or red in a context menu? With ContextMenu.Controls.Add(Type:=msoControlButton, before:=6) .OnAction = "'" & ThisWorkbook.Name & "'!" & "RTO_EVENT" .FaceId = 353 .Caption = "BUSINESS/WORK EVENT" End With

I am having an issue that I am hoping some more experienced DAX programmers may be able to help me with. This problem is cross-posted on StackOverflow here (excel - Medians and slicers in DAX - Stack Overflow) with no answers so far. I have been trying to develop a dashboard in Excel 2013 /...

I'm trying to better understand the order/manner of determining filter context, and came across a conundrum that I couldn't explain. The 2 measures below produce significantly different results. (A) CALCULATE(SUM([SalesAmount]), LASTDATE(DimDate[FullDateAlternateKey]) ) (B)...

In a protected sheet I've put a picture with some command buttons on it. I've also use custom menubars and disabled right click for cut, copy, paste. However, although the picture is locked, when I hit mouse right button I get enabled the context items for the picture (like Show Picture...