Forum Discussion

LeaRupnik's avatar
LeaRupnik
Helper III
4 years ago
Solved

SQL Statment to DAX

Hello,  a have sql statment, how to do this in dax. select CAST(sum([CPP Real_pro_kol])/1000 as INT) as sum_Real_pro_kol ,[CPP Datum_posnetka] as datum_posnetka ,year([CPP Datum_posnetka]) as leto...
Help
  • LeaRupnik's avatar
    LeaRupnik
    4 years ago

    Hello

    I am adding a description of what I need. I have data entered in the table for each day. I would like to return only for maximum data in each year plus month. That is, for 2020 and January, I would only need data from 31.1.2020

     

    thanks

    Lea

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi LeaRupnik ，

Could you pls share some sample data ,and what you get final by the sql . Remember to remove confidential data.

 

 

Best Regards

Lucien