To do this, I basically subtracted the January of current year [% of Base Group] value from the current [% of Base Group] value then added on the net change that had occurred in January. I have a column in my date table that shows YYYYMM as a value so I was able...
Sales[SalesMonth]&'Warranty Claim Parts'[ClaimdateMonth]both are in same format YYYYMM Note that in this one I gave hard dates in warranty claims table by merging sales start date table which restrict me from using other legends or say another upper hierarchy level legend such as model code...
MaxMonthMonth = month(Calculate(MAX(V_F_ASSETS[asset_date]);Allselected(V_F_ASSETS)))Current Month # Assets =CALCULATE(COUNTROWS(V_F_ASSETS);filter(V_F_ASSETS;MONTH(V_F_ASSETS[asset_date])=[MaxMonthMonth])) Note: I have one Month Slicer and this measure is to prevent the...
In response to diogormatas 07-20-2016 02:51 AM @diogormatas Try MaxMonthMonth = month(Calculate(MAX(V_F_ASSETS[asset_date]),All(V_F_ASSETS))) Current Month # Assets = CALCULATE( COUNTROWS(V_F_ASSETS), filter(V_F_ASSETS, MONTH(V_F_ASSETS[asset_date])= MONTH(MAX(V_F_AS...
So as Many-Many Relationship arises to avoid that I created Calendar Bridge Table which is DISTINCT(DateTable[YYYYMM])Relationship will be likeFactTable[Month]-Calendar[YYYYMM]Calendar[YYYYMM]-DateTable[YYYYMM](Bidirectional Filtering) All the above calculations I created are Measures only TIA ...
add a calculated column in your date table new column=if(format([date],"yyyymm")=format(today(),"yyyymm")&&[date]<=today(),1,0) then use this new column to filter your slicer Message 4 of 6 725 Views 0 Reply Anonymous Not applicable In response to wdx223_Daniel 02-16...
add a calculated column in your date table new column=if(format([date],"yyyymm")=format(today(),"yyyymm")&&[date]<=today(),1,0) then use this new column to filter your slicer Message 4 of 6 926 Views 0 Reply Anonymous Not applicable In response to wdx223_Daniel 02-16...