Getting date for calculation

Stack Overflow Asked by Faizan Gauhar on December 12, 2020

I am a new user of Power BI and I was wondering if it is possible to calculate the date difference that is present in two different tables but they both are connected to the third table in which I want to create a measure or a column using dax to calculate date difference:

enter image description here

The columns marked in red are dates and I want their difference to be calculated in the assumption table. I used the month number to build the relationship between these tables.

powerbi powerbi desktop

One Answer

You can use a Measure as below-

date_diff = 
DATEDIFF(
    RELATED(d_nl[notification]), 
    RELATED(d_fc[file_closure_date]), 
    DAY
)

To know about other Intervals rather than DAY, you can visit Here.

Answered by mkRabbani on December 12, 2020

Getting date for calculation

One Answer

Add your own answers!

Related Questions

Scanner is skipping nextLine() after using next() or nextFoo()?

Creating a Message for Gmail API in C#

exclude certain projects from using Directory.Build.props

Angular custom webpack config enable CSS modules

How can i save the fulfillmentText in dialogflow to firebase?

how do I seed data to firebase firestore

How to speed up dataframe std() calculation on each row?

“Operation canceled” Realm Error Domain=io.realm.unknown Code=89

OpenCV Frame Grabber not work on MacOS Catalina

relative rotation in 3D

Scaffold-DbContext doese not add [DatabaseGenerated(DatabaseGeneratedOption.Computed)] on Generated class

PHP+SOAP. Is it possible to make multiple tries creating new SoapClient?

Process.StandardOutput.ReadToEnd() is always Empty

How to Mock the ActivityContext Class

How to execute a function from second ViewController after popViewController?

Nested array into array, adding brackets around nested array

When I compile my code I get a message what does it mean

Is it possible to override the create_migration template in Rails 6?

“Unresolved import” error for Python built-ins in vscode on macOS

Plugin: Waterwheel Image Carousel. How do I add only text?

Ask a Question