It can be seen in CSV after export. There is a huge gap between "2018" and "Q1":

On quarter column is 8 but on my calculation is 34... strange

Propably sad to hear that, but it doesnt work either.

Nope, the trim function still doesnt change anything.

The first one doesnt work, the second one works. What a strange case that is...

Ok, so now without any general filters, only using filters inside columns: 1. FILTER("Historical Pipeline Facts"."Open Opportunity Revenue" USING ("Pipeline Snapshot Date"."Pipeline Snapshot Enterprise Quarter" = (CASE WHEN RIGHT('@{QUARTER}', 1) = '1' THEN CAST(CAST(LEFT('@{QUARTER}', 4) AS INTEGER) -1 AS CHAR)||'…

This time I used the AGO function correctly but got an error " [nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join Fact_CrmOpportunityAM_RevenueTimeBasedSnapshot_Summary_Quarter_Dim_CrmAnalyticsAM_CrmAnalyticsModelAM_CrmFiscalDayPVO_Common. (HY000)" And then I found on the…

Ok seems like I get it now, in one row the conditions together are not possible. That is why I propably dont get any results. Robert - the filter option with for example: FILTER("Historical Pipeline Facts"."Closed Opportunity Revenue" USING ("Pipeline Snapshot Date"."Pipeline Snapshot Enterprise Quarter" = (CASE WHEN…

Robert - again didnt worked, still no results. Christian, Thomas - I would really appreciate to get this "simple" solution since you already commented my case. This SQL is issued that way because the column with Quarter IS NOT A DATE and even if casted to, the format would still be "2018 Q 2" and that still I CANNOT use to…

Well, yes, they should be. First is the passed variable @Quarter and the second should just be using the previously passed variable.

One more photo of the issued SQL:

Robert - unfortunately this doesnt change anything... Joel - can you give me an example of ago function with a presentation variable? Just remember that prompted quarted is from one Subject Area and the quarter ago is from Historical Pipeline.

Im sorry Robert, right bracket exists, I just omitted it here accidentaly... Also all the values are like "2018 Q 1" so my spaces are correct, again I just mistyped it here Here is the proof that data are correct:

Ok I know, but there are many other details that prevents me from using this method. Mainly because I have to prompt for a Quarter and I have to see a data from that Quarter and historical data from quarter -1. And I dont know if function ago can support this. It has to be done through a presentation variable. Do you have…