Forum Discussion

jeffgarlisch's avatar
jeffgarlisch
Icon for Helper I rankHelper I
7 years ago

Numeric Range Slicer only use available values

Hey All,    I have a date dimension table with integer values for financial months.                                                               eg. 201801...201805...201806....201812   What i...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi jeffgarlisch

Assume you have a dataset like this,

"date" is numeric yearmonth field, but "date2" is the correct month associated with "date1", but "date2" doesn't exsit in your dataset.

 

Could you show me the first numeric yearmonth and the last numeric yearmonth, so i can analyze the rule to transform from this type numeric yearmonth to the correct date type.

 

Best Regards

Maggie

jeffgarlisch's avatar
jeffgarlisch
Icon for Helper I rankHelper I
7 years ago

My Data Looks like this for the month year data, we store date dim data on a daily level so i selected the MIN and MAX of the datevalue column to show the date range of what the month year should be looking at. 

 

Please let me know if this is what youre looking for. 

 

 

 

 

 

 

 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi jeffgarlisch

    From this table, i can't see anything like " 201812....201833.....201875".

    Which column do you add in the slicer?

    It is not clear for me how this table relate to your original table?

     

    Best Regards

    Maggie