Forum Discussion
Bring a date value to calculated column
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")1 Reply
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-to/first-unread-message
