Calculated dimension

[#1]

Hi Experts,

i want to display on current month's date in my dimension.

i have a variable set as vMTD = '>=' & Date(MonthStart(Today()-1)) & '<=' & Date(Today()-1)

How can i create a dimension in my straight table. Please help.

[sunny_talwar]

This variable looks more like a candidate for set analysis. Do you specifically wanted to use calculated dimension for current month?

[#3]

Yes sunny please

I want only current month's dates in the chart excluding today.

Please help

[sunny_talwar · Accepted solution]

I don't really understand if you want set analysis or calculated dimension, but I guess here are both options

1) Calculated dimension (Remember to select 'Suppress When Value Is Null')

If(DateField >= MonthStart(Today()) and DateField < Today(), DateField)

2) Set Analysis

Sum({<DateField = {"$(='>=' & Date(MonthStart(Today()), 'DateFieldFormatHere') & '<' & Date(Today(), 'DateFieldFormatHere'))"}>} Measure)

[#5]

Thank u so much sunny