Hi gurus,
I am trying to build a Bar chart where one of the bars is populated from one query and the second one from a second query. I have tried to union them and use the union but it fails with error messages (attached).
Query 1
Gets input for month year from a user (this is done by a macro in the slicer) and calculates a measure
Query
Uses the macro and lag function to build the same measure value for previous period
eg. if query 1 builds
revenue for
feb/2014
query 2 builds revenue for
Feb/2013
I am not sure how to proceed from here
you don't need a union since you are using dimensional. you just need to build a set..
set([input from user];lag([input from user];1);lag([input from user];2))
Thanks a ton Khayman! It is working... :)