Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
I am re-creating the Data Module in Cognos Analytics from my PowerBi Data Module. I have a measure I created in PowerBi but don't know to to implement in Cognos. need some help.The DAX measure in PowerBi is :
I'm not familiar with your expression syntax in PowerBI, but what I think I see is your calculated dates are (1) the first day of the today's calendar year and (2) yesterday's date.
Expressions in Cognos syntax would be:
If you were trying to use these together in a "I only want the dates between, and including, this range" expression, it would be:
[YOUR DATE FIELD TO FILTER UPON] BETWEEN (<Put First Expression Here>) AND (<Put Second Expression Here>)
Note: there are a number of ways to calculate the first expression above, so there's various options to get the first day of the current calendar year. Expression two is pretty straightforward and probably the go-to manner for calculating yesterday's date (or doing +/- days on any date for that matter).
You should have a look to relative date analysis. With this feature, you can easily query year-to-date measure.
The following filters are predefined and can be used: