Re: Need help for calculated column

Anonymous · ‎04-07-2020

I am building one report in which I am getting data from azure devops. I have 1 data set in which I am fetching task details. I am creating duplicate of this dataset on daily basis, so that I can calculate task details daily. But here the issue is when any new task is added in the main dataset, calculated column is not returning data for the new task.

Can someone please help here?

v-shex-msft · ‎04-13-2020

Hi @Anonymous,

What dataset did you use to stored these new records? The original dataset or the duplicate dataset?
If your records append on the duplicate dataset and calculate column are calculated based on the raw dataset, I don't think it will be effect by other table records.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Greg_Deckler · ‎04-08-2020

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...