Forum Discussion
kdaya
Helper I
Helper IHow to view first 3 months
Hi Power BI Community, Please can someone help me on how i can view the first 3 months of data: basically each customer has a different starting date so i cannot use the slicer as this uses t...
kdayaHelper I
Helper Ithanks for your help, can you please tell me why you *100?
v-haibl-msft
Microsoft Employee
Microsoft Employee
Just give a good format for the YearMonth column which data type is whole number, so that we can rank it correctly.
We can also not *100, but in that case, YearMonth will be 2016 +5 = 2021 instead of 201600 + 5 = 201605.
Best Regards,
Herbert