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_posnetka
,month([CPP Datum_posnetka]) as mesec_posnetka
,[CPP Leto] as leto
,[CPP Mesec] as mesec
from
[cisppr].[f CPP Cista prodajna premija] t1
inner join
(
select
max([CPP Datum_posnetka]) as leto_Datum_posnetka
from
[cisppr].[f CPP Cista prodajna premija]
group by
year([CPP Datum_posnetka])
,month([CPP Datum_posnetka])
) as t2 on t1.[CPP Datum_posnetka]= t2.leto_Datum_posnetka
where
[CPP Datum_posnetka] <= '2022-03-28'
--[CPP Datum_posnetka] <= '2020-12-31'
--and [CPP Leto] =2021



group by
year([CPP Datum_posnetka])
,month([CPP Datum_posnetka])
,[CPP Datum_posnetka]
,[CPP Leto]
,[CPP Mesec]
order by
year([CPP Datum_posnetka])
,month([CPP Datum_posnetka])
,[CPP Datum_posnetka]
,[CPP Leto]
,[CPP Mesec]

 

thx

LEa

  • 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

3 Replies