dax

[AjithTravvise]

Hello All,

    I am very new DAX and I mapush to work on this because of current situation. Please look into the below scenario and help me calculate the DAILY VALUE

Table Name : Sales

Country	Date	Periodic Value	Daily Value
India	1/1/2020	100
India	2/2/2020	150
India	3/3/2020	250

[Greg_Deckler]

Wild guess on this one because I have no idea what you are expecting for Daily Value: https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185#M111

[AjithTravvise]

I wanted to add one new column with daily value

[AjithTravvise]

Hi Greg,

     This worked, but when I am applying filter by Country its not working

Regards

Ajith 

[Pragati11 · Accepted solution]

Hi @AjithTravvise ,

In your DAX formula, replace "ALL" with "ALLSELECTED".

This will take into consideration any filters you are applying like the COUNTRY.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[AjithTravvise]

What i noticed is if the value is 0 it returns -ve figure.

[Pragati11]

HI @AjithTravvise ,

Can you please provide some details on how you want this DAILY VALUE to be caluclated? There is no reference in your question to what you want and it's impossible to answer.

Thanks,

Pragati

[AjithTravvise]

Now i am unable to generate a daily sales report since i have only incremental values. I wanted to break it down to daily. I hope i am clear with my requirement.

[Pragati11]

Hi @AjithTravvise ,

Simple question - How can you generate daily sales if you don't have data for it? As you say you have got incremental values not daily values.

Thanks,

Pragati

[AjithTravvise]

Hi Pragati,

     I need help in creating a measure for calculate the daily sales value.

Regards

Ajith