Bring a date value to calculated column

[kafreitass]

Hello, Guys!

Someone could help me?

I would like to make a comparison between the date of the table dProjects and the date of the table fRealizado, but how would I bring this value to a calculated column? I want to create a status by doing this comparison. For example: If date x from table fRealizado is greater than the current date and valueRepassed is less than column y, return Active, otherwise stand by

I'm trying to use the following function:

Status Projeto = 

VAR DtLancamento = SELECTEDVALUE(fRealizado[Dt. Lançto Módulo (1º Repasse/Venda)])


RETURN

    IF(DtLancamento <= TODAY(),
        IF([Qtde Repasses - Realizado] = [Total Lote], "Concluído","Ativo"),"Stand by")

[danextian]

Hi @kafreitass ,

While it is possible to use a measure in a calculated column, the return is static until the dataset is refreshed.

https://community.powerbi.com/t5/Desktop/Using-measures-in-calculated-columns/m-p/101386

There may be a work around for your use case but there's not enough information. Here's how you can get a better response: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump...