Month to Date

[agraffeo21]

I would like to make a column for Month/Month and Year/Year. I have already done this in excel but it seems that Power Bi will not let me make some numbers in a column percentages, and some decimal numbers. (As seen in my "value" column, I have my value, PCSI, then I have the PCSI MTD/YTD, which were percentages in excel, and are now decimals.)

Is there a way I can make a measurement for Month/Month and Year/Year, still holding the same table format I have? (I must do it with a "value type" column to keep consistency with my date column.)

Thank you.

[v-sihou-msft]

@agraffeo21

In Power BI Desktop, you can't set dynamic format within same column. You can only keep single format for a column. Please vote this idea.

Regards,