Forum Discussion

Helper III

8 years ago

I need Measure data format

HI anybody help me MY 3 reports i am using SSAS is source 1st report scenario :i am using Matrix Row is Name Column is Year value is amount anybody help Column shoulbe Two columns one is Curre...

Super User

8 years ago

Abduvali how are you connecting to SSAS? Is it live query or import?

Helper III

8 years ago

Hi parry,
I am connecting live query.

Anonymous
Not applicable
8 years ago
Aruna_ln,

For your first question, in "Connect Live" mode, when you put year in Column of Matrix visual, it is not possible to use measure in Power BI Desktop to limit the column to show current year and previous year. I would recommend you limit year to current year and last year using MDX or DAX query at the beginning that you connect to SSAS database.

About your second question, do you want to show amount of last 12 month? If so, you can create measure as described in this similar thread.

About the third question, create the following measures.

Amount of Current Year Month = CALCULATE(SUM('Table'[Amount]), FILTER('Table',YEAR('Table'[Date])=YEAR(TODAY())&&MONTH('Table'[Date])=MONTH(TODAY())))

Amount of last Year Month = CALCULATE(SUM('Table'[Amount]), FILTER('Table',YEAR('Table'[Date])=YEAR(TODAY())-1&&MONTH('Table'[Date])=MONTH(TODAY())))

If above measures don't help, please share sample data and post expected result in table format.

Regards,
Lydia