Calendar all the month Using DAX

[RajK2]

Dear Team,

I've Fact table which have data like

Apple have 12 months data

Orange have 3 months data

Banana have 4 months data

if i filter fact table for orange it will show 12 months period instead of 3 months where we don't have data then also it will show on particular month as zero. My table view should be fixed as 12 months.

what is DAX Formula ?

Orange                     Apple

[bhanu_gautam]

Are you creating measure or column, create column instead of measure

[RajK2]

Hi,

I've shared the sample data as ideally have 20+ columns of data.

columns

Month, Type, Value, Qty, GG Value, TR Value, KN Value etc....

Measure field as SUM Of 'ADJ Value' and we need to 12 months report view incase no data on particular months.

[bhanu_gautam]

@RajK2 , You can create new column for this using formula

FixedTable = 
ADDCOLUMNS(
   SUMMARIZE('FactTable', 'FactTable'[Fruit]),
   "Month", IF(COUNTROWS('FactTable') > 0, 'FactTable'[Month], BLANK()),
   "Value", IF(COUNTROWS('FactTable') > 0, 'FactTable'[Value], 0)
)

 and use this table in visualization 

[RajK2]

Dear Bhanu,

Thanks for response.

Value is calculated using measure however this may not works so end up with error

Measure created like Adj Value = Amount / Qty