Forum Discussion

Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago
Solved

Measure dissapers when published file refreshes

I have two measures : ActualMeasure_HD = (     CALCULATE(         SUM(CombinedTable[Amount]),         CombinedTable[Source] = "Actual"     ) ) and    BudgetMeasure_HD = (     CAL...
  • Dwivedi15's avatar
    Dwivedi15
    1 year ago

    I think I did it 

     

     -  While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY. 

Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago

Hi I tried this :

BudgetMeasure_HD =
VAR BudgetAmount =
    CALCULATE(
        SUM(CombinedTable[Amount]),
        CombinedTable[Source] = "Budget"
    )
RETURN
IF(
    ISBLANK(BudgetAmount),
    0,
    BudgetAmount
)
Now  after this published file gets refreshed-  I can see budegt measure is only working for january data . Other all months become zero
 



Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago

I think I did it 🙂 -  While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.