Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, i have dax measure for calculated column like this
RealisasiEkvUSDCumTest:= VAR MaxDate = CALCULATE(MAX(DimDate[Date]) , RELATEDTABLE(FactInvestment)) RETURN CALCULATE ( SUM ( FactInvestment[RealisasiEkvUSD]), FILTER ( ALLSELECTED(DimDate), DimDate[Date] <= MaxDate) ) |
but, i want remove that month have no value like image below (blank value is Oct-Dec), Thanks ...
Solved! Go to Solution.
Hi,
See below;
RealisasiEkvUSDCumTest:=
VAR MaxDate = CALCULATE(MAX(DimDate[Date]) , RELATEDTABLE(FactInvestment))
RETURN
If (is blank(sum(FactInvestment[RealisasiEkvUSD]) ) = true(), blank(),
CALCULATE (
SUM ( FactInvestment[RealisasiEkvUSD]),
FILTER (
ALLSELECTED(DimDate),
DimDate[Date] <= MaxDate)
))
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
You can try the following formula
RealisasiEkvUSDCumTest:=
VAR _MaxDate = CALCULATE(MAX(DimDate[Date]) , RELATEDTABLE(FactInvestment))
RETURN
IF( SELECTEDVALUE(DimDate[Date])<=_MaxDate ,
CALCULATE (
SUM ( FactInvestment[RealisasiEkvUSD]),
DATESYTD(DimDate[Date]))
)
You can try the following formula
RealisasiEkvUSDCumTest:=
VAR _MaxDate = CALCULATE(MAX(DimDate[Date]) , RELATEDTABLE(FactInvestment))
RETURN
IF( SELECTEDVALUE(DimDate[Date])<=_MaxDate ,
CALCULATE (
SUM ( FactInvestment[RealisasiEkvUSD]),
DATESYTD(DimDate[Date]))
)
Hi,
See below;
RealisasiEkvUSDCumTest:=
VAR MaxDate = CALCULATE(MAX(DimDate[Date]) , RELATEDTABLE(FactInvestment))
RETURN
If (is blank(sum(FactInvestment[RealisasiEkvUSD]) ) = true(), blank(),
CALCULATE (
SUM ( FactInvestment[RealisasiEkvUSD]),
FILTER (
ALLSELECTED(DimDate),
DimDate[Date] <= MaxDate)
))
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |