Error in measure in Power BI

[Analitika]

Hello,

I would like to ask how I could fix this issue in measure

The MIN function only accepts a column reference as the argument number 1.

20_2_1_DATA PRADELSIMAS = 
VAR SlicerDate =
    MAX ( 'Date'[Date] )
VAR pradzia =
    CALCULATE (
        MIN ([dm]),
        FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= SlicerDate )
    )
VAR pradelstos_dienos =
    DATEDIFF ( pradzia, SlicerDate, DAY )
RETURN
    IF (
        ABS ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] ) > 0.01,
        CALCULATE ( pradelstos_dienos, FILTER ( 'Date', 'Date'[Date] <= SlicerDate ) )
    )

Here measure. I am using measure in min function.

[NaveenGandhi]

Hello @Analitika 

Min function will only accept column as input, If you want to to use a measure, try the below change.

Minx('Table Name',[dm])

Note that this might give you wong numbers due to the fact that you haven't given a explanation and sample data on what you are trying to achieve.

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[Analitika]

dm=values(date)

[NaveenGandhi]

@Analitika 

You can use the min(date) in this scenario.

[Analitika]

Main problem is whenever I add date column in table visual, then resources exceeded. And table didn't load.

[NaveenGandhi]

@Analitika 

Can you explain a bit more about what you are trying to achieve and what is the problem you are facing along with some screenshots and sample data?

[Analitika]

My problem is whenever I try to add date column visual table, then getting resources exceeded, and table are not viewable. I can't find how to optimize something in order to put additional column in table. I tried use measure for table but it didn't help too.

[NaveenGandhi]

@Analitika 

It would be better if you explain on what is the no of tables, table size ,how does the data model look like.

[Analitika]

It is just table visual.