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
Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
7 years ago

Assuming you are using calendar table,  create the below calculated column: 

 

Year Month = FORMAT('Calendar'[Date],"YYYYMM")