Dashboard

[bhatsu]

Hi Folks,

I have a data set, with columns like Metrics name, Date, Numerator, Denomintaor
Metrics Name= Text
Date=Date
Numerator/Denominator= Numbers ( Also contains Negative values)

So, we have to show Num divided by Den, group by Metrics name and bifurcated in Dates. So for an example, in Matrix visual, we will have Rows=Metrics Name
Column=Date
Values=Num/Deno
along with the additional columns
Current to Previous Month variance
Q1, Q2,Q..... depending upton what month is being selected in Date Slicer Visual
YTD
PY ( Previous Year)

Visual should be like this:
Metrics Name PreviousMonth  Current Month MonthVariance                         6 Month Trend Sparkline  Q1  Q2  YTD  PY
ABC                   223445               34567             (Curren-Previous)/Previous %
DEF                   212345               36879                 Same as above
GHI                   223564               34566                 Same as above

And Condition is:
Whatever month_year is selected on the Slicer, that month should be considerd as the current month hence all those numbers should change dynamically.
2. There should be no interm month over month variance for example, it should reflect as showed in the above structure. Reffering to quick measures.

Please help.

Thanks in advance.

[v-juanli-msft]

Hi @bhatsu

For your first condition,

create a calendar date table, then manage the relationship between calendar table and the original table without making this relationship active.

create a measure

currentmonth = ALLSELECTED('Table'[month-year])

 add the month column from the calendar date table to a slicer,

Best Regards

Maggie

[v-juanli-msft]

Hi @bhatsu

Do you accept to make some changes on Power BI Desktop? It seems that what's you want need to be obtained by DAX.

Best Regards

Maggie

[bhatsu]

Hi Maggie,

Yes, I am doing it on Power Bi desktop and it does need Advanced DAX help.
Let me know if question asked above isn't understandable.