topic Re: dax in DAX Commands and Tips

dax

AjithTravvise — Wed, 08 Apr 2020 10:45:34 GMT

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

Re: dax

Pragati11 — Wed, 08 Apr 2020 10:52:08 GMT

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

Re: dax

Greg_Deckler — Wed, 08 Apr 2020 10:52:42 GMT

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

Re: dax

AjithTravvise — Wed, 08 Apr 2020 10:57:27 GMT

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.

Re: dax

Pragati11 — Wed, 08 Apr 2020 11:03:47 GMT

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

Re: dax

AjithTravvise — Wed, 08 Apr 2020 11:05:21 GMT

Hi Greg,

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

Regards

Ajith

Re: dax

AjithTravvise — Wed, 08 Apr 2020 11:07:17 GMT

Hi Pragati,

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

Regards

Ajith

Re: dax

Pragati11 — Wed, 08 Apr 2020 11:11:42 GMT

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

Re: dax

AjithTravvise — Wed, 08 Apr 2020 11:16:33 GMT

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

Re: dax

AjithTravvise — Wed, 08 Apr 2020 11:23:54 GMT

I wanted to add one new column with daily value